References
CREATE ROLE
statement official documentation: https://www.postgresql.org/docs/current/sql-createrole.htmlALTER ROLE
statement official documentation: https://www.postgresql.org/docs/current/sql-alterrole.htmlDROP ROLE
statement official documentation: https://www.postgresql.org/docs/current/sql-droprole.htmlGRANT
statement official documentation: https://www.postgresql.org/docs/current/sql-grant.htmlREVOKE
statement official documentation: https://www.postgresql.org/docs/current/sql-revoke.html- PostgreSQL
pg_roles
catalog details: https://www.postgresql.org/docs/current/view-pg-roles.html - PostgreSQL
pg_authid
catalog details: https://www.postgresql.org/docs/current/catalog-pg-authid.html - PostgreSQL ACL documentation: https://www.postgresql.org/docs/current/ddl-priv.html
- PostgreSQL host-based access rule details: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html
- PostgreSQL ACL utility functions...