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> wrote: > On Tuesday, May 17, 2022, Chirag Karkera <chiragkrkr...@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. > >
