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.
