TIL - create-new-role-in-postgres

GRANT CONNECT ON DATABASE postgres TO "<USER>";
GRANT USAGE ON SCHEMA public TO "<USER>";
GRANT SELECT, INSERT, UPDATE, DELETE ON public.<TBL_NAME> TO "<NAME>";
SELECT table_name, privilege_type
FROM information_schema.table_privileges
WHERE grantee = '<GRANTEE>';