Create User and Role

Docs: Examples of Create Role

CREATE ROLE whoami WITH LOGIN PASSWORD 'P@ssw0rd';

Create Database

Docs: Examples of Create Database

CREATE DATABASE sales OWNER whoami;