Re: Clarification on Role Access Rights to Table Indexes

From: Ayush Vatsa <ayushvatsa1810(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Clarification on Role Access Rights to Table Indexes
Date: 2025-02-19 10:23:48
Message-ID: CACX+KaNAbOzePn710EtzH9F5xiUdBC+u59=UMab=Wr8jgDKQtw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hello Everyone,
It seems there's a general consensus that we should maintain a
original design to support pg_prewarm, with a minor adjustment:
when querying indexes, we should verify the privileges of the parent table.

I’ve attached a patch for this, which includes some test cases as well.
Let me know if it needs any changes.

Regards,
Ayush Vatsa
SDE AWS

Attachment Content-Type Size
v1-0001-Improve-ACL-checks-in-pg_prewarm-for-indexes.patch application/octet-stream 4.8 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ayush Vatsa 2025-02-19 10:31:32 Re: Clarification on Role Access Rights to Table Indexes
Previous Message Csányi Pál 2025-02-19 10:23:18 ERROR: stack depth limit exceeded

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2025-02-19 10:26:55 Re: Added schema level support for publication.
Previous Message Amit Kapila 2025-02-19 10:13:30 Re: Introduce XID age and inactive timeout based replication slot invalidation