> On 30 Sep 2024, at 10:29, btsugieyuusuke <btsugieyuus...@oss.nttdata.com> 
> wrote:
> 
> Hi hackers,
> I found a flaw in the ACL_MAINTAIN comment.
> 
> Commands such as VACUUM are listed as commands that are allowed to be 
> executed by the MAINTAIN privilege.
> However, LOCK TABLE is missing from the comment.
> 
>> /*
>> * Check if ACL_MAINTAIN is being checked and, if so, and not already set
>> * as part of the result, then check if the user is a member of the
>> * pg_maintain role, which allows VACUUM, ANALYZE, CLUSTER, REFRESH
>> * MATERIALIZED VIEW, and REINDEX on all relations.
>> */
> 
> Therefore, shouldn't LOCK TABLE be added to the comment?

That's correct, for the list to be complete LOCK TABLE should be added as per
the attached.

--
Daniel Gustafsson

Attachment: acl_maintain_comment.diff
Description: Binary data

Reply via email to