On 11/17/22 17:07, David Gauthier wrote:
> psql (11.5, server 11.3) on linux
>
> Someone who had privileges in a lot of tables/schemas/DBs left the
> company. I want to drop that role but "rop role xxx" won't let me
> because... "xxx cannot be dropped because some objects depend on it".
>
> Is there a way to just get rid of this role without revoking xxx in all
> the individual DB objects he has privs too? Something like "drop role xxx
> cascade" ?
Had this idea tonight about how to find what is owned by a specific role.
Haven't tested it, so the syntax might be a bit wrong, and it might not work:
$ pg_dump --schema-only $DATABASE | grep OWNER | grep $OLDEMPLOYEE
--
Angular momentum makes the world go 'round.