REASSIGN OWNED is great, but "DETAIL: privileges for ..." is also a cause
for DROP ROLE to fail.
Thus (via a script, of course, that loops through every database and every
schema in that database, and for every object you can grant to), I've got
to REVOKE ALL ON {object type} IN SCHEMA ... FROM some_role, then REVOKE
ALL ON SCHEMA ... FROM some_role.
Is there a single command that I'm missing?
(Yes, I know privileges should be granted to groups. The archaic some_role
which I just dropped is a group role.)
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!