The view administrable_role_authorizations identifies all roles that the current user has the admin option for.
Table 33-2. administrable_role_authorizations Columns
Name | Data Type | Description |
---|---|---|
grantee | sql_identifier | Name of the role to which this role membership was granted (can be the current user, or a different role in case of nested role memberships) |
role_name | sql_identifier | Name of a role |
is_grantable | character_data | Always YES |