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

ADM_SYS_PRIVS

ADM_SYS_PRIVS displays information about system permissions granted to users and roles. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

Table 1 ADM_SYS_PRIVS columns

Name

Type

Description

grantee

character varying(128)

Name of the user or role to which the permission is granted.

privilege

character varying(40)

System permission

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.