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