Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>

To: Michael Paquier <michael@paquier.xyz>

Cc: Jeff Davis <pgsql@j-davis.com>, Ted Yu <yuzhihong@gmail.com>, Pavel Luzanov <p.luzanov@postgrespro.ru>, Justin Pryzby <pryzby@telsasoft.com>, pgsql-hackers@postgresql.org

Date: 2023-06-15T23:57:00Z

Lists: pgsql-hackers

Attachments

v2-0001-partial-revert-of-ff9618e82a.patch (text/x-diff)

On Wed, Jun 14, 2023 at 09:10:44PM -0700, Nathan Bossart wrote:
> IMO
> we should update the docs and leave out the ownership checks since MAINTAIN
> is now a grantable privilege like any other.  WDYT?

Here's an attempt at adjusting the documentation as I proposed yesterday.
I think this is a good opportunity to simplify the privilege-related
sections for these maintenance commands.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com

Commits

Improve privilege documentation for maintenance commands.
- c2122aae636d 16.0 landed
Fix cache lookup hazards introduced by ff9618e82a.
- 4dbdb82513b6 16.0 landed
Move bool parameter for vacuum_rel() to option bits.
- 5b1a87994312 16.0 landed
Fix MAINTAIN privileges for toast tables and partitions.
- ff9618e82a46 16.0 landed
Add grantable MAINTAIN privilege and pg_maintain role.
- 60684dd834a2 16.0 landed