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: Alvaro Herrera <alvherre@alvh.no-ip.org>, Pavel Luzanov <p.luzanov@postgrespro.ru>, pgsql-hackers@postgresql.org

Date: 2022-12-14T23:29:39Z

Lists: pgsql-hackers

On Wed, Dec 14, 2022 at 11:05:13AM -0800, Jeff Davis wrote:
> On Wed, 2022-12-14 at 10:16 -0800, Nathan Bossart wrote:
>> Okay.  Should all the privileges governed by MAINTAIN apply to a
>> relation's
>> TOAST table as well?
> 
> Yes, I agree.

This might be tricky, because AFAICT you have to scan pg_class to find a
TOAST table's main relation.

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