APPLICABLE_ROLES view

This Information Schema view displays one row for each role grant. Roles can be granted to individual users and other roles.

For more information about roles and grants, see Overview of Access Control.

See also:

ENABLED_ROLES view , OBJECT_PRIVILEGES view , TABLE_PRIVILEGES view

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.