Updated on 2024-05-07 GMT+08:00

ROLE_SYS_PRIVS

ROLE_SYS_PRIVS displays information about system privileges granted to roles (only roles accessible to the user are displayed). By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

Table 1 ROLE_SYS_PRIVS columns

Name

Type

Description

role

character varying(128)

Role name.

privilege

character varying(40)

System permission granted to a role

System permissions include rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcatupdate, rolcanlogin, rolreplication, rolauditadmin, rolsystemadmin, roluseft, rolmonitoradmin, roloperatoradmin, and rolpolicyadmin.

admin_option

character varying(3)

Specifies whether the grant contains the ADMIN option.

  • YES
  • NO

common

character varying(3)

Not supported. Its value is NULL.

inherited

character varying(3)

Not supported. Its value is NULL.