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

# Applicable roles

The `information_schema.applicable_roles` view lists the roles that are granted to the current user, as well as those the user either owns or has the [necessary privilege to manage](/overview/security/rbac/role-permissions#role-permissions).

You can use a `SELECT` query to return information about each role as shown in the example below.

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

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

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

See also `information_schema.transitive_applicable_roles` [here](/reference-sql/information-schema/transitive-applicable-roles).

<Note>
  Read more about RBAC roles [here](/guides/security/rbac).
</Note>

## Columns in information\_schema.applicable\_roles

Each row has the following columns with information about the role.

| Column Name   | Data Type   | Description                                                         |
| :------------ | :---------- | :------------------------------------------------------------------ |
| grantee       | TEXT        | User or role to whom the role is granted.                           |
| role\_name    | TEXT        | Name of the role.                                                   |
| is\_grantable | TEXT        | `YES` if the grantee has the admin option on the role, `NO` if not. |
| created       | TIMESTAMPTZ | Creation time of the role.                                          |