Information schema for applicable_roles
You can use the information_schema.applicable_roles view to return information about roles available in the account. You can use a SELECT query to return information about each role as shown in the example below.
SELECT
*
FROM
information_schema.applicable_roles;
Read more about RBAC roles here.
Columns in information_schema.applicable_roles
Each row has the following columns with information about the role.
| Column Name | Data Type | Description |
|---|---|---|
| grantee | TEXT | Role or user to whom the privilege is granted (TO USER|ROLE). |
| 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. |