| From: | Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> |
|---|---|
| To: | Jeff Davis <jdavis(at)postgresql(dot)org>, pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pgsql: Add grantable MAINTAIN privilege and pg_maintain role. |
| Date: | 2023-04-15 18:47:07 |
| Message-ID: | 766f3799-0269-162f-ba63-4cae34a5534f@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
On 14.12.22 02:35, Jeff Davis wrote:
> Add grantable MAINTAIN privilege and pg_maintain role.
>
> Allows VACUUM, ANALYZE, REINDEX, REFRESH MATERIALIZED VIEW, CLUSTER,
> and LOCK TABLE.
>
> Effectively reverts 4441fc704d. Instead of creating separate
> privileges for VACUUM, ANALYZE, and other maintenance commands, group
> them together under a single MAINTAIN privilege.
>
> Author: Nathan Bossart
> Discussion: https://postgr.es/m/20221212210136.GA449764@nathanxps13
> Discussion: https://postgr.es/m/45224.1670476523@sss.pgh.pa.us
This commit removed RangeVarCallbackOwnsTable(), but there is still a
mention of it in a comment in src/backend/commands/tablecmds.c. Maybe
that mention can simply be removed, or the comment rephrased.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2023-04-16 00:05:57 | pgsql: Improve VACUUM/ANALYZE BUFFER_USAGE_LIMIT docs |
| Previous Message | Tom Lane | 2023-04-15 16:01:50 | pgsql: Fix assignment to array of domain over composite, redux. |