> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/information-schema/enabled-roles",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

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

# Enabled roles

The `information_schema.enabled_roles` view lists roles in a Firebolt **account** that is either owned by a user or comes with [role privileges](/overview/security/rbac/role-permissions#role-permissions) to access.

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

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
  *
FROM
  information_schema.enabled_roles;
```

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

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
  *
FROM
  org_db.information_schema.enabled_roles;
```

<Note>
  For more information about permissions to access and perform operations on specific objects by role, see [Manage role-based access control](/guides/security/rbac).
</Note>

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