David Gauthier <dfgpostgres@xxxxxxxxx> 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
