Re: Provide read-only access to system catalog tables

Поиск
Список
Период
Сортировка
От Chirag Karkera
Тема Re: Provide read-only access to system catalog tables
Дата
Msg-id CANZL2iEX_D5vLt75N3Y8HgYk09EF9g33UGFw7kOQyFZK07TVVw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Provide read-only access to system catalog tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Provide read-only access to system catalog tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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.g.johnston@gmail.com> wrote:
On Tuesday, May 17, 2022, Chirag Karkera <chiragkrkr102@gmail.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.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: Estimation of recovery times in postgres
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Provide read-only access to system catalog tables