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

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>

To: Jeff Davis <pgsql@j-davis.com>

Cc: pgsql-hackers@postgresql.org

Date: 2022-12-14T03:23:32Z

Lists: pgsql-hackers

On Tue, Dec 13, 2022 at 07:05:10PM -0800, Jeff Davis wrote:
> Committed.
> 
> The only significant change is that it also allows LOCK TABLE if you
> have the MAINTAIN privilege.

Thanks!

> I noticed a couple issues unrelated to your patch, and started separate
> patch threads[1][2].

Will take a look.

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