Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ System Catalogs and System Views/ System Views/ User and Permission Management/ MY_SYS_PRIVS
Updated on 2024-08-20 GMT+08:00
View PDF
Share

MY_SYS_PRIVS

MY_SYS_PRIVS displays information about system permissions granted to the current user. By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schemas.

Table 1 MY_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 permissions or ANY permissions of the user.

  • System permissions include rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcatupdate, rolcanlogin, rolreplication, rolauditadmin, rolsystemadmin, roluseft, rolmonitoradmin, roloperatoradmin, and rolpolicyadmin.
  • For details about the value of the ANY permissions, see Table 1.

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.