The information_schema.enabled_roles view lists roles in a Firebolt account that is either owned by a user or comes with role privileges to access.

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

SELECT
  *
FROM
  information_schema.enabled_roles;

Similarly, you can use the org_db.information_schema.enabled_roles to view enabled roles in your organization:

SELECT
  *
FROM
  org_db.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 NameData TypeDescription
role_nameTEXTThe name of the role.
createdTIMESTAMPTZThe time that the role was created.
role_ownerTEXTThe name of the user who created the role.