Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ System Catalogs and System Views/ System Views/ MY_SYS_PRIVS
Updated on 2025-08-19 GMT+08:00
View PDF

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 schema.

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 permission

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.
Parent topic: System Views