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.