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.
>
>