Applicable roles

The information_schema.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. You can use a SELECT query to return information about each role as shown in the example below.

SELECT
  *
FROM
  information_schema.applicable_roles;

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

The org_db catalog and organization-level information schema views are not supported in Firebolt OSS.

SELECT
  *
FROM
  org_db.information_schema.applicable_roles;

See also information_schema.transitive_applicable_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	User or role to whom the role is granted.
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.

Account info

Catalogs

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Columns in information_schema.applicable_roles

​Columns in information_schema.applicable_roles

Columns in information_schema.applicable_roles