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

MY_ROLE_PRIVS

MY_ROLE_PRIVS displays permission information about roles (including the public role) 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_ROLE_PRIVS columns

Name

Type

Description

grantee

character varying(128)

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

granted_role

character varying(128)

Role to be granted.

admin_option

character varying(3)

Specifies whether the grant contains the ADMIN option.

  • YES
  • NO

delegate_option

character varying(3)

Not supported. Its value is NULL.

default_role

character varying(3)

Not supported. Its value is NULL.

os_granted

character varying(3)

Not supported. Its value is NULL.

common

character varying(3)

Not supported. Its value is NULL.

inherited

character varying(3)

Not supported. Its value is NULL.