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

See also

• PostgreSQL: Database roles, CREATE USER, CREATE ROLE, \du, \du+, create user, Alter user
• PostgreSQL Privileges, GRANT, \list+, \du+