Re: Provide read-only access to system catalog tables - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Provide read-only access to system catalog tables
Date
Msg-id CAKFQuwYOfH3Gr3XB3Waf1gM6xn9ntZ6_mc6mwOiw=-6531S=tQ@mail.gmail.com
Whole thread Raw
In response to Re: Provide read-only access to system catalog tables  (Chirag Karkera <chiragkrkr102@gmail.com>)
Responses Re: Provide read-only access to system catalog tables
List pgsql-hackers
On Tue, May 17, 2022 at 6:21 AM Chirag Karkera <chiragkrkr102@gmail.com> wrote:
Thanks David for your reply!

But when i created a role i am not able to view objects under information_schema.* 

I mean I am not able to view the data, I can see only the column names. 


Which goes to demonstrate you have permissions.  But information_schema uses the permissions of the executing user to decide what to show - it is pre-filtered (and doesn't address PostgreSQL-only features).  If you need less restrictive behavior your best bet is to just use the system catalogs.  Those give you everything.

David J.

pgsql-hackers by date:

Previous
From: Chirag Karkera
Date:
Subject: Re: Provide read-only access to system catalog tables
Next
From: Ranier Vilela
Date:
Subject: Re: Avoid unecessary MemSet call (src/backend/utils/cache/relcache.c)