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.
Each row has the following columns with information about the role.
|Role or user to whom the privilege is granted (TO USER|ROLE).
|Name of the role.
|YES if the grantee has the admin option on the role, NO if not.
|Description of the role.
|Creation time of the role.
|Name of the user that created the role.
|Time the role was last altered.
|Name of the last user to edit the role.