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

> 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](/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":"css-variables","dark":"css-variables"}}
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":"css-variables","dark":"css-variables"}}
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](/security/guides/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.                                          |