APPLICABLE_ROLES view¶
This Information Schema view displays one row for each role grant applied to the currently authenticated user.
For more information about roles and grants, see Overview of Access Control.
- See also:
ENABLED_ROLES view , OBJECT_PRIVILEGES view , TABLE_PRIVILEGES view , GRANTS_TO_USERS view , GRANTS_TO_ROLES view , SHOW GRANTS
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
GRANTEE |
TEXT |
Role or user to whom the privilege is granted |
ROLE_NAME |
TEXT |
Name of the role |
ROLE_OWNER |
TEXT |
Owner of the role |
IS_GRANTABLE |
TEXT |
Whether this role can be granted to others |
Usage notes¶
The view does not display any information about database roles.