PostgreSQL > Create DB
Create a new user:
CREATE USER user_name WITH ENCRYPTED PASSWORD 'mypassword';
GRANT ALL PRIVILEGES ON DATABASE sample_db TO user_name;
To grant all necessary permissions:
GRANT pg_read_all_data TO mv_dgexp;
GRANT pg_write_all_data TO mv_dgexp;