Re: [PATCH] pg_permissions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCH] pg_permissions
Date
Msg-id 1320012.1616691115@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] pg_permissions  ("Joel Jacobson" <joel@compiler.org>)
Responses Re: [PATCH] pg_permissions  ("Joel Jacobson" <joel@compiler.org>)
List pgsql-hackers
"Joel Jacobson" <joel@compiler.org> writes:
> On Thu, Mar 25, 2021, at 16:16, Alvaro Herrera wrote:
>> Ah, of course -- the only way to obtain the acl columns is by going
>> through the catalogs individually, so it won't be possible.  I think
>> this could be fixed with some very simple, quick function pg_get_acl()
>> that takes a catalog OID and object OID and returns the ACL; then
>> use aclexplode() to obtain all those details.

> +1 for adding pg_get_acl().

I wonder what performance will be like with lots o' objects.

            regards, tom lane



pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently
Next
From: Andres Freund
Date:
Subject: Re: shared memory stats: high level design decisions: consistency, dropping