Enabled roles

Use this reference to learn about the metadata available about roles using the information schema.

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:

The org_db catalog and organization-level information schema views are not supported in Firebolt OSS.

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 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.