Create a PostgreSQL user and grant access to database

PostgreSQL is a great database engine, especially when used with Django.

In this simple tutorial we will

1. Create a USER

    CREATE USER johnnybravo WITH PASSWORD 'bulletproof';
   

2. Create a DATABASE

    CREATE DATABASE johnnybase;
   

3. Give the USER full access to the DATABASE

    GRANT ALL PRIVILEGES ON DATABASE johnnybase to johnnybravo;
   

That's it! Your terminal should look like

[email protected]:~$ sudo su postgres
[email protected]:~$ psql
psql (9.4.1)
Type "help" for help.

postgres=# CREATE USER johnnybravo WITH PASSWORD 'bulletproof';
CREATE ROLE
postgres=# CREATE DATABASE johnnybase;
CREATE DATABASE
postgres=# GRANT ALL PRIVILEGES ON DATABASE johnnybase to johnnybravo;
GRANT
postgres=# \q