Re: Provide read-only access to system catalog tables

From: Chirag Karkera <chiragkrkr102(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Provide read-only access to system catalog tables
Date: 2022-05-17 13:21:03
Message-ID: CANZL2iEX_D5vLt75N3Y8HgYk09EF9g33UGFw7kOQyFZK07TVVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Thanks.

Regards,
Chirag Karkera

On Tue, May 17, 2022 at 6:40 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tuesday, May 17, 2022, Chirag Karkera <chiragkrkr102(at)gmail(dot)com> wrote:
>>
>>
>> the user has to be provided the read only access on system catalog tables
>> (information_schema and pg_catalog)
>>
>
> All roles have this, no action required.
>
> David J.
>
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2022-05-17 13:29:31 Re: Provide read-only access to system catalog tables
Previous Message Bharath Rupireddy 2022-05-17 13:13:52 Estimation of recovery times in postgres