Postgres Permissions

Create the user:

createuser usernamehere

Remainder is in the psql shell.

Set password:

\password USERNAME

Grant connect permission (source):

revoke connect on database DBNAME from public;
grant all privileges on database DBNAME to USERNAME;

Grant table permissions:

\c DBNAME
grant all privileges on all tables in schema public to USERNAME;

Set default table permissions:

alter default privileges in schema public grant all privileges on tables to USERNAME;