Create a role when first starting up the PostgreSQL DB

-- Login as postgres and Create DB, User

docker exec -it postgres-driver psql -U postgres
CREATE DATABASE driver;
CREATE USER adrian WITH ENCRYPTED PASSWORD 'password'

-- Check the users

\du

-- Grant privileges of DB driver to user and check DBs

GRANT ALL PRIVILEGES ON DATABASE driver TO adrian;
\l

-- Get Into DB

\c driver

-- Grant privileges of Tables and Sequences In Schema public to user

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO adrian;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO adrian;

-- Grant create of DB and Schema public to user

GRANT CREATE ON DATABASE driver TO adrian;
GRANT CREATE ON SCHEMA public TO adrian;