The information_schema.applicable_roles view shows every role in the account and its grantees, who include other users or roles to whom the role is granted. 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: 
SELECT
  *
FROM
  org_db.information_schema.applicable_roles;
See also information_schema.transitive_applicable_roles here.
Read more about RBAC roles here.

​
Columns in information_schema.applicable_roles

Each row has the following columns with information about the role.
Column NameData TypeDescription
granteeTEXTUser or role to whom the role is granted.
role_nameTEXTName of the role.
is_grantableTEXTYES if the grantee has the admin option on the role, NO if not.
createdTIMESTAMPTZCreation time of the role.