ENABLED_ROLES view

This Information Schema view displays a row for each currently-enabled role in the session. A role is enabled if it is currently in use in the session or it has been granted to the role that is currently in use.

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

See also:

APPLICABLE_ROLES view , OBJECT_PRIVILEGES view , TABLE_PRIVILEGES view

Columns

Column Name

Data Type

Description

ROLE_NAME

TEXT

Name of the role

ROLE_OWNER

TEXT

Owner of the role

Usage notes

  • The view only displays objects for which the current role for the session has been granted access privileges.

  • The view always displays the PUBLIC role because it is always enabled.

  • The view does not display any information about database roles.