Robert Haas <robertmh...@gmail.com> writes: > On Mon, Feb 17, 2025 at 5:18 PM David G. Johnston > <david.g.johns...@gmail.com> wrote: >>> I have a very vague recollection that we concluded that SELECT >>> privilege was a reasonable check because if you have that you >>> could manually prewarm by reading the table. That would lead >>> to the conclusion that the minimal fix is to look at the owning >>> table's privileges instead of the index's own privileges.
>> I feel like if you can blow up the cache by loading an entire table into >> memory with just select privilege on the table we should be ok with allowing >> the same person to name an index on the same table and load it into the >> cache too. > +1. Is that a +1 for the specific design of "check SELECT on the index's table", or just a +1 for changing something here? regards, tom lane