Horton

Re: Granting SET and ALTER SYSTE privileges for GUCs

Mark Dilger <mark.dilger@enterprisedb.com>

View thread View on postgr.es
From: Mark Dilger <mark.dilger@enterprisedb.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Robert Haas <robertmhaas@gmail.com>, Jeff Davis <pgsql@j-davis.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>, Joshua Brindle <joshua.brindle@crunchydata.com>
Date: 2021-12-13T21:33:58Z
Lists: pgsql-hackers

Attachments


> On Dec 13, 2021, at 12:58 PM, Mark Dilger <mark.dilger@enterprisedb.com> wrote:
> 
> Give me a few minutes and I'll repost.

Ok, this new version is rebased, cleaned up, and has the ability to revoke SET VALUE on most settings which were previously userset, but are now suset with initdb time granted SET VALUE privilege to public.

I have not yet altered gucs defined by contrib modules, but will repost in a few hours, or tomorrow, with those changes.

Commits

  1. Allow granting SET and ALTER SYSTEM privileges on GUC parameters.