Skip to content

Instantly share code, notes, and snippets.

@eculver

eculver/postgres-perms.sh

Last active December 28, 2015 01:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save eculver/7423884 to your computer and use it in GitHub Desktop.
Save eculver/7423884 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres-perms.sh
# create user
CREATE USER myuser WITH PASSWORD 'mypassword';
# create database
CREATE DATABASE mydatabase;
# grant access to user
GRANT ALL PRIVILEGES ON DATABASE mydatabase TO myuser;
# grant just create
ALTER USER myuser CREATEDB;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment