yeah I'm on 9.5, but thanks for the info. On Fri, Apr 3, 2020 at 1:24 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> 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+. > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
