Re: Granting SET and ALTER SYSTE privileges for GUCs - Mailing list pgsql-hackers

From Mark Dilger
Subject Re: Granting SET and ALTER SYSTE privileges for GUCs
Date
Msg-id C8DF19D8-C15D-4C2D-91CA-391390F1E421@enterprisedb.com
Whole thread Raw
In response to Re: Granting SET and ALTER SYSTE privileges for GUCs  (Mark Dilger <mark.dilger@enterprisedb.com>)
Responses Re: Granting SET and ALTER SYSTE privileges for GUCs
List pgsql-hackers

> On Jan 26, 2022, at 7:24 AM, Mark Dilger <mark.dilger@enterprisedb.com> wrote:
>
> Rebased:
>
> <v7-0001-Allow-GRANT-of-SET-and-ALTER-SYSTEM-SET-for-gucs.patch>

Hackers,

Joshua and I had some off-list back-and-forth on this patch and I think the attached v8 patch meets his needs.
Specifically,v8 adds support for object access hooks in the case of SET and ALTER SYSTEM SET of a guc variable. 

The way InvokeObjectPostAlterHookArg() is written, it expects some things like a Oid that we don't always have.  I
abusedthe parameters of that function to pass as much information as possible.  Anyone wanting to review this might
considerhow that is coded. 

Joshua, this is byte-for-byte the same patch that you already reviewed off-list (or I attached the wrong patch!)  If
youare satisfied, could you set the status to ready-for-committer? 



—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




Attachment

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: PITR: enhance getRecordTimestamp()
Next
From: Michael Banck
Date:
Subject: Re: CREATEROLE and role ownership hierarchies