sudo -u postgres psql

CREATE DATABASE <DB_NAME>;
CREATE USER <USER> WITH PASSWORD '<USER_PWD>';
ALTER ROLE <USER> SET client_encoding TO 'utf8';
ALTER ROLE <USER> SET default_transaction_isolation TO 'read committed';
ALTER ROLE <USER> SET timezone TO 'UTC';
GRANT ALL PRIVILEGES ON DATABASE <DB_NAME> TO <USER>;
\q

grant select, insert, update, delete on <TABLE_NAME_1>, <TABLE_NAME_2> to <USER>;