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

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>

To: Ted Yu <yuzhihong@gmail.com>

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

Date: 2023-01-09T22:51:57Z

Lists: pgsql-hackers

Attachments

v4-0001-fix-MAINTAIN-privs.patch (text/x-diff)

On Tue, Jan 03, 2023 at 03:45:49PM -0800, Nathan Bossart wrote:
> I'd like to get this fixed, but I have yet to hear thoughts on the
> suggested approach.  I'll proceed with adjusting the tests and
> documentation shortly unless someone objects.

As promised, here is a new version of the patch with adjusted tests and
documentation.

-- 
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