PostgreSQL: Database roles

• https://www.postgresql.org/docs/current/database-roles.html

Create role:

• create role
• create user

• CREATE USER name WITH Role XXX

List users and roles:

• \du
• \du+
• SELECT rolname FROM pg_roles;
• SELECT * FROM pg_roles;

Assign roles:

• GRANT "your-defined role" TO "your username";

Related terms

• CREATE ROLE, create user
• Schema
• GRANT privileges to roles
• Superuser
• rds_superuser role in AWS RDS
• Ansible roles
• ALTER USER myuser WITH SUPERUSER;
• DROP ROLE
• community.postgresql.postgresql_privs
• \list+

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+