Transitive applicable roles

Use this reference to learn about the metadata available about roles using the information schema.

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.

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.

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:

SELECT
  *
FROM
  org_db.information_schema.transitive_applicable_roles;

See also information_schema.applicable_roles here.

Read more about RBAC roles here.

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.