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 schemas.
| 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.
|
| 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
