Database management

Todo

(Optional) Don’t let public connect to your database:

REVOKE CONNECT ON DATABASE ${USERNAME} FROM PUBLIC;

Give a different user access to your database/schema:

GRANT CONNECT ON DATABASE ${DATABASE} TO ${USERNAME};
GRANT USAGE ON SCHEMA ${SCHEMA} TO ${USERNAME};
GRANT SELECT ON ALL TABLES IN SCHEMA ${SCHEMA} TO ${USERNAME};