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

# Transitive applicable roles

The `information_schema.transitive_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).

Unlike, `information_schema.applicable_roles` that shows only direct grantees, `information_schema.transitive_applicable_roles` also shows indirect grantees.
For example, if role `engineer` is granted to role `manager` and role `manager` is granted to user `alice` then user `alice` is a direct grantee of `manager` and an indirect grantee of `engineer`.

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.transitive_applicable_roles;
```

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

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SELECT
  *
FROM
  org_db.information_schema.transitive_applicable_roles;
```

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

<Note>
  Read more about RBAC roles [here](/security/guides/rbac#check-assigned-privileges-using-sql).
</Note>

## Columns in information\_schema.transitive\_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 (directly or indirectly).  |
| 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.                                          |