public inbox for [email protected]
help / color / mirror / Atom feedFrom: Isaac Morland <[email protected]>
To: Joel Jacobson <[email protected]>
Cc: [email protected]
Subject: Re: Add pg_get_acl() function get the ACL for a database object
Date: Wed, 19 Jun 2024 10:23:45 -0400
Message-ID: <CAMsGm5deS=Qk9OHK_jCOBOpt=RHb2UxKdXfCeXzPoi_yjwiSVA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Wed, 19 Jun 2024 at 07:35, Joel Jacobson <[email protected]> wrote:
> Hello hackers,
>
> Currently, obtaining the Access Control List (ACL) for a database object
> requires querying specific pg_catalog tables directly, where the user
> needs to know the name of the ACL column for the object.
>
I have no idea how often this would be useful, but I wonder if it could
work to have overloaded single-parameter versions for each of regprocedure
(pg_proc.proacl), regclass (pg_class.relacl), …. To call, just cast the OID
to the appropriate reg* type.
For example: To get the ACL for table 'example_table', call pg_get_acl
('example_table'::regclass)
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Add pg_get_acl() function get the ACL for a database object
In-Reply-To: <CAMsGm5deS=Qk9OHK_jCOBOpt=RHb2UxKdXfCeXzPoi_yjwiSVA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox