Skip to content

Instantly share code, notes, and snippets.

@edwinlab

edwinlab/postgresql_create_user_no_superuser.sql

Created December 8, 2017 09:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save edwinlab/3a2460dfaf5e2c8d19f809b45b750c73 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save edwinlab/3a2460dfaf5e2c8d19f809b45b750c73 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgresql_create_user_no_superuser.sql
CREATE ROLE your_role NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;
ALTER ROLE your_role WITH PASSWORD ‘your_password';
GRANT USAGE ON schema public TO your_role;
GRANT SELECT, UPDATE, INSERT, DELETE ON your_table TO your_role;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment