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	VARCHAR	Role or user to whom the privilege is granted
ROLE_NAME	VARCHAR	Name of the role
ROLE_OWNER	VARCHAR	Owner of the role
IS_GRANTABLE	VARCHAR	Whether this role can be granted to others

The view does not display any information about database roles.