Re: Granting SET and ALTER SYSTE privileges for GUCs

> On Mar 28, 2022, at 12:11 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> writes:
>> Version 12 also introduces \dcp (pneumonic, "Describe Configuration Parameter") for listing parameters, with \dcp+ also showing the acl, like:
>
> The fact that that code is not dry behind the ears is painfully obvious.

<snip>

> On the whole perhaps this should be taken out again

I added the \dcp command after noticing that doc/src/sgml/ddl.sgml's "Summary of Access Privileges" table had an empty column for the "psql Command" column for the "PARAMETER" row. Maybe that's ok. I thought it would be better if I added a command for that.

I don't feel too strongly about it, so I'm removing \dcp from this patch with the intention of introducing it as a separate patch for the postgres 16 development cycle. For now, I'm just putting "none" in that table cell.

This patch also moves the grant/revoke tests in guc_privs.sql into the unsafe_tests directory, fixes them up to be repeatable, and drops the superuser role that had been negligently left around in prior patches. The tests that had been added in privileges.sql are simply removed.