Information schema for enabled_roles

The information_schema.enabled_roles view provides information about roles available within a Firebolt account.

The following code example uses a SELECT query to return information about each role:

SELECT
  *
FROM
  information_schema.enabled_roles;

For more information about permissions to access and perform operations on specific objects by role, see Manage role-based access control.

Columns in information_schema.enabled_roles

Each row contains the following columns with information about the role:

Column Name	Data Type	Description
role_name	TEXT	The name of the role.
created	TIMESTAMPTZ	The time that the role was created.
role_owner	TEXT	The name of the user who created the role.