Postgres Pro
Downloads
Home   >   mailing lists

Re: Add pg_get_acl() function get the ACL for a database object - Mailing list pgsql-hackers

From Isaac Morland
Subject Re: Add pg_get_acl() function get the ACL for a database object
Date
Msg-id CAMsGm5deS=Qk9OHK_jCOBOpt=RHb2UxKdXfCeXzPoi_yjwiSVA@mail.gmail.com
Whole thread Raw
In response to Add pg_get_acl() function get the ACL for a database object  ("Joel Jacobson" <joel@compiler.org>)
Responses Re: Add pg_get_acl() function get the ACL for a database object
List pgsql-hackers
Tree view
On Wed, 19 Jun 2024 at 07:35, Joel Jacobson <joel@compiler.org> 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)

pgsql-hackers by date:

Previous
From: "Joel Jacobson"
Date:
Subject: Re: Add pg_get_acl() function get the ACL for a database object
Next
From: Alexander Pyhalov
Date:
Subject: Re: Inconsistency between try_mergejoin_path and create_mergejoin_plan