PostgreSQL Privileges

https://www.postgresql.org/docs/current/ddl-priv.html

• SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, USAGE, SET and ALTER SYSTEM

• GRANT UPDATE ON accounts TO joe;

Related

• Privileges
• Ansible: community.postgresql.postgresql_privs
• \list+
• \du+
• PostgreSQL users
• Terraform resource: postgresql_grant

News

• Oct 2022 PostgreSQL 15, revokes the CREATE permission from all users except a database owner from the public (or default) schema

See also

• PostgreSQL: Database roles, CREATE USER, CREATE ROLE, \du, \du+, create user, Alter user
• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE
• PostgreSQL Privileges, GRANT, \list+, \du+

https://www.postgresql.org/docs/15/ddl-schemas.html#DDL-SCHEMAS-PATTERNS