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

From David G. Johnston
Subject Re: Clarification on Role Access Rights to Table Indexes
Date
Msg-id CAKFQuwZ+EsCJHmBVdHeJ2XUWUBSGtN8k2icrX2hrPR=m7sLNGg@mail.gmail.com
Whole thread Raw
In response to Re: Clarification on Role Access Rights to Table Indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Clarification on Role Access Rights to Table Indexes
List pgsql-general
On Monday, February 17, 2025, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ayush Vatsa <ayushvatsa1810@gmail.com> writes:
> postgres=> SELECT pg_prewarm('pg_class_oid_index');
> ERROR:  permission denied for index pg_class_oid_index

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.

David J.

pgsql-general by date:

Previous
From: Ayush Vatsa
Date:
Subject: Re: Clarification on Role Access Rights to Table Indexes
Next
From: Tom Lane
Date:
Subject: Re: Clarification on Role Access Rights to Table Indexes