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};