On 11/17/22 17:16, Tom Lane wrote:
David Gauthier <dfgpostg...@gmail.com> writes:
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" ?
Not directly, but see REASSIGN OWNED and DROP OWNED.
SIMULATE and VERBOSE options would be handy, to see what those commands
would actually do.
--
Angular momentum makes the world go 'round.
