Thank you for the clarification.
Will use the system catalogs tables.
Thank You.
Regards,
Chirag Karkera
On Tue, May 17, 2022 at 6:59 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Tue, May 17, 2022 at 6:21 AM Chirag Karkera
> wrote:
>
>> Thanks David for your reply!
>>
>> But
On Tue, May 17, 2022 at 6:21 AM Chirag Karkera
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 perm
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.johns...@gmail.com
On Tuesday, May 17, 2022, Chirag Karkera 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.
Hi Team,
Appreciate your time to look into this.
I have a requirement, where a user has to be provided DDL access on the
schema (which is provided to the user) and as there is some development
work in process the user has to be provided the read only access on system
catalog tables (information_s