Re: Granting SET and ALTER SYSTE privileges for GUCs

Mark Dilger <mark.dilger@enterprisedb.com>

From: Mark Dilger <mark.dilger@enterprisedb.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Andrew Dunstan <andrew@dunslane.net>, Jeff Davis <pgsql@j-davis.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>

Date: 2021-11-24T02:14:54Z

Lists: pgsql-hackers

Attachments

v4-0001-Allow-GRANT-of-SET-and-ALTER-SYSTEM-for-variables.patch (application/octet-stream) patch v4-0001
(unnamed) (text/plain)

> On Nov 23, 2021, at 8:07 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> 
> It's my impression that information_schema is a child of the SQL
> standard, and that inventions specific to PG go in pg_catalog.
> 
> Also, I think the user-facing name for GUCs is "settings".

Thanks.  These issues should be fixed in v4.

Along the way, I also added has_setting_privilege() functions overlooked in v3 and before.

Commits

Allow granting SET and ALTER SYSTEM privileges on GUC parameters.
- a0ffa885e478 15.0 landed