CREATE DATABASE mydb;
CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass';
GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser
-- pg 15+
\c mydb
GRANT ALL ON SCHEMA public TO myuser;