Information schema
Enabled roles
Use this reference to learn about the metadata available about roles using the information schema.
The
Similarly, you can use 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:
org_db.information_schema.enabled_roles to view enabled roles in your organization:
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. |