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