Use this reference to learn about the metadata available about roles using the information schema.
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:
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. |