David Gauthier <dfgpostgres(at)gmail(dot)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.
regards, tom lane