REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role? - Mailing list pgsql-admin

From Ron Johnson
Subject REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?
Date
Msg-id CANzqJaDu+7q9i=-vwUsX-ZZRTKSCCCG7FVF32X7XhPo1E4Xpxg@mail.gmail.com
Whole thread Raw
List pgsql-admin
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!

pgsql-admin by date:

Previous
From: Kouber Saparev
Date:
Subject: pg_combinebackup failure
Next
From: Scott Ribe
Date:
Subject: Re: REVOKE ALL ON ALL OBJECTS IN ALL SCHEMAS FROM some_role?