Re: Provide read-only access to system catalog tables

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

Re: Provide read-only access to system catalog tables

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

Re: Provide read-only access to system catalog tables

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

Re: Provide read-only access to system catalog tables

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.