Link Search Menu Expand Document

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.


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.