Skip to content

Instantly share code, notes, and snippets.

@gpad

gpad/read_only_user.sql

Created April 4, 2020 08:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gpad/0e9130d2994eada1efac1c6f2f49f0f4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save gpad/0e9130d2994eada1efac1c6f2f49f0f4 to your computer and use it in GitHub Desktop.
Download ZIP
Script to create read_only user in PG
Raw
read_only_user.sql
CREATE ROLE <user_name> WITH LOGIN PASSWORD '<password>' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
GRANT CONNECT ON DATABASE <db> TO <user_name>;
\c <db>
GRANT USAGE ON SCHEMA public TO <user_name>;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO <user_name>;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO <user_name>;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO <user_name>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment