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.