Skip to content

Instantly share code, notes, and snippets.

@icavalheiro

icavalheiro/read_perm_pgsql.sql

Last active August 28, 2019 15:00
Show Gist options
  • Save icavalheiro/63d57afedb15842cf88487d198733afd to your computer and use it in GitHub Desktop.
Save icavalheiro/63d57afedb15842cf88487d198733afd to your computer and use it in GitHub Desktop.
Download ZIP
Grant read permissions to user Postgres
Raw
read_perm_pgsql.sql
GRANT CONNECT
ON DATABASE database_name
TO user_name;
GRANT SELECT /*, INSERT, UPDATE, DELETE */
ON ALL TABLES IN SCHEMA public
TO user_name;
Raw
remove_perm.sql
REVOKE SELECT/*, INSERT, UPDATE, DELETE */ ON table_name FROM user_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment