Re: Clarification on Role Access Rights to Table Indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: Clarification on Role Access Rights to Table Indexes
Date
Msg-id 861660.1739819589@sss.pgh.pa.us
Whole thread Raw
In response to Re: Clarification on Role Access Rights to Table Indexes  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Monday, February 17, 2025, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> You'd really have to take that up with the author of pg_prewarm.

> This is our contrib module so this seems like the expected place to ask
> such a question.  It’s neither a bug nor a topic for -hackers.  FTR, Robert
> Haas is the author from 2013.  Not sure he monitors -general though.

Ah, you are right, I was thinking it was a third-party extension.

If we're talking about changing the behavior of a contrib module,
I think -hackers would be the appropriate location for that.
And it does seem like this deserves a fresh look.  As it stands,
a superuser can prewarm an index (because she bypasses all
privilege checks including this one), but nobody else can.
Seems weird.

            regards, tom lane



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Clarification on Role Access Rights to Table Indexes
Next
From: Laurenz Albe
Date:
Subject: Re: Clarification on Role Access Rights to Table Indexes