Provide read-only access to system catalog tables

From: Chirag Karkera <chiragkrkr102(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Provide read-only access to system catalog tables
Date: 2022-05-17 12:54:41
Message-ID: CANZL2iFrC9=j6okL0pxSQWKxzrj3wrdP8b0_S8=+iDs=aswmEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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_schema and pg_catalog)

I have surfed a lot of materials online, but did not get any solution for
the same.

Request you to share some valuable input on this.

Thank You.

Regards,
Chirag Karkera

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2022-05-17 13:02:57 Re: Data is copied twice when specifying both child and parent table in publication
Previous Message Ashutosh Bapat 2022-05-17 12:49:53 Re: Tracking notnull attributes inside Var