On 4/3/20 10:18 AM, Adrian Klaver wrote: > On 4/2/20 9:59 PM, AC Gomez wrote: >> Granted. But we are where we are, so I'm assuming this is going to be >> hand to hand combat. > > Well you could even the odds somewhat by using the below as a starting > point: > > > SELECT > relname, > pg_roles.rolname, > acl.* > FROM > pg_class, > aclexplode(relacl) AS acl > JOIN pg_roles ON acl.grantee = pg_roles.oid > WHERE > pg_roles.oid = 'some_role'::regrole; >
Possible flaw in plan, the above only works with v12+.