Thread: How to revoke access and list schema objects
Hi, There are are some people who use my database and I want to prevent them to read code of tables and funtions. I have created a schema in which only postgres user can have access. Other users can not use objects in this but they can list all sql code for each object if they use pgadmin. What is the command to prevent users to list objects and prevent them to read the sql code. Thanks
For a production system, you can use this configuration :
--ACCESS DB
REVOKE CONNECT ON DATABASE nova FROM PUBLIC;
GRANT CONNECT ON DATABASE nova TO user;
--ACCESS SCHEMA
REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT USAGE ON SCHEMA public TO user;
--ACCESS TABLES
REVOKE ALL ON ALL TABLES IN SCHEMA public FROM PUBLIC ;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only ;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO read_write ;
GRANT ALL ON ALL TABLES IN SCHEMA public TO admin ;Hi,
There are are some people who use my database and I want to prevent them
to read code of tables and funtions. I have created a schema in which
only postgres user can have access. Other users can not use objects in
this but they can list all sql code for each object if they use pgadmin.
What is the command to prevent users to list objects and prevent them to
read the sql code.
Thanks