applicable_roles

The applicable_roles view provides information about all roles whose privileges the current user can use.

Column name	Data type	Description
grantee	sql_identifier	The name of the role to which the role membership was granted.
role_name	sql_identifier	The name of the role.
is_grantable	yes_or_no	Specifies whether the role membership can be granted to other roles. The possible values are: YES – The grantee has administrative privileges on the role. NO – The grantee doesn’t have administrative privileges on the role.