Skip to content

Instantly share code, notes, and snippets.

@davidlivingrooms

davidlivingrooms/create_user_with_privs.sql

Created October 17, 2015 23:06
Show Gist options
  • Save davidlivingrooms/6bb3a5dc7eedb1f91d9a to your computer and use it in GitHub Desktop.
Save davidlivingrooms/6bb3a5dc7eedb1f91d9a to your computer and use it in GitHub Desktop.
Download ZIP
Add new postgresql user with privs
Raw
create_user_with_privs.sql
CREATE USER openmicer;
GRANT ALL PRIVILEGES ON database openmicnight TO openmicer;
GRANT ALL PRIVILEGES ON openmic TO openmicer;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment