PostgreSQL Configuration

3 min

purpose in postgresql, the goal is to allow the user \[username] to read data from specific schemas (e g , public, information schema, etc ) and from catalog tables if necessary grant permission postgresql grant select on all tables under " public " grant select on all tables in schema public to \[ username ]; \ grant select on all tables under " information schema " grant select on all tables in schema information schema to \[ username ]; \ allow select on pg catalog tables grant select on pg catalog pg class to \[ username ]; grant select on pg catalog pg attribute to \[ username ]; grant select on pg catalog pg database to \[ username ]; grant select on pg catalog pg collation to \[ username ]; grant select on pg catalog pg tables to \[ username ]; grant select on pg catalog pg views to \[ username ]; \ allow select on information schema tables grant select on information schema columns to \[ username ]; grant select on information schema views to \[ username ]; grant select on all tables in schema < schema name > to \[ username ]; testing permissions to verify that \[username] can read from the postgresql catalogs or schema tables, execute postgresql example test for pg catalog select from pg catalog pg tables ; if the user can run this query without an error, the privileges have been successfully applied