Re: [PATCH] pg_permissions

On Thu, Mar 10, 2022, at 22:02, Chapman Flack wrote:
> It looked to me as if the -hackers messages of 25 and 26 March 2021 had
> found a consensus that a pg_get_acl() function would be a good thing,
> with the views to be implemented over that.
>
> I'm just not seeing any later patch that adds such a function.

My apologies for late reply. Here it comes.

Recap: This patch is about adding two new system views: pg_privileges and pg_ownerships.

Changes since patch 0005 from 2021-03-25:

- Implement SQL-callable pg_get_acl()
This is a stripped down version of AlterObjectOwner_internal() from alter.c.

- Rename pg_permissions -> pg_privileges

- Use pg_shdepend + pg_get_acl() in pg_privileges, to avoid slow UNION ALL.

- Fix indentation of the new system views to be consistent with the other views.

- Add documentation of pg_get_acl() to func.sgml

- Move documentation of system views from catalogs.sgml to system-views.sgml

- Much smaller patch, thanks to getting rid of the long UNION ALL view definition:
1 file changed, 195 insertions(+), 460 deletions(-)

/Joel