Product Documentation

Appearance

7.3.2
7.2.3
7.1.2
7.0.2
6.9.3
5.4.17
5.2.32

sys.role ​

This system view returns a list of roles.

Superusers can see all roles in this view. Users and roles with CREATE ROLE, ALTER ANY ROLE, or DROP ANY ROLE privilege can also see all roles in this view.

Users and roles that are not superusers and do not have (or inherit) CREATE ROLE, ALTER ANY ROLE, or DROP ANY ROLE privilege can only see their own accounts in this view.

Note: This view returns only those roles and users that are created with the NOLOGIN attribute. Roles and users with LOGIN access are not included. See also sys.user.

Column NameData TypeDescription
role_idbigintUnique role ID.
nametextName of the role.
create_rolebooleanWhether this role has the privilege to create other roles.
create_databasebooleanWhether this role has the privilege to create databases.
superuserbooleanWhether this role has superuser privileges.
ldap_synchronizedbooleanWhether this role is synchronized via an LDAP server group. See Synchronizing Users and Groups.
memberofname[]Which roles this role is a member of, if any.

Examples ​

For example:

premdb=# select * from sys.role;
 role_id |  name  | create_role | create_database | superuser | ldap_synchronized | memberof 
---------+--------+-------------+-----------------+-----------+-------------------+----------
   16486 | qa     | t           | t               | f         | f                 | {}
   16485 | backup | f           | f               | f         | f                 | {}
(2 rows)

The following role is not listed in sys.role because it does not have the login attribute:

premdb=# create role bar_role login;
CREATE ROLE
premdb=# select * from sys.role where name='bar_role';
 role_id | name | create_role | create_database | superuser | ldap_synchronized | memberof 
---------+------+-------------+-----------------+-----------+-------------------+----------
(0 rows)

Parent topic:System Views