Help Center> GaussDB> Centralized_3.x> System Catalogs and System Views> System Views> ROLE_ROLE_PRIVS
Updated on 2024-05-07 GMT+08:00
View PDF

ROLE_ROLE_PRIVS

ROLE_ROLE_PRIVS displays roles granted to other roles and provides only information about the roles that the user has access to. By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

Table 1 ROLE_ROLE_PRIVS columns

Name

Type

Description

role

character varying(128)

Role name.

granted_role

character varying(128)

Role to be granted.

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