Re: Drop role cascade ?

On 11/17/22 17:16, Tom Lane wrote:
> David Gauthier <dfgpostgres@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.