all_role_privs ?
If a user has been granted a role with admin option, then they are allowed to grant other users access to the role. Surely then, there should be a data dictionary view which allows them to see who has been granted the role. I would have expected this to be all_role_privs but there isn't one, and non dbas cannot see dba_role_privs.
What I am trying to achieve is an application where users take responsibility for which users are members of roles they have been granted admin on, particularly revoking inappropriate permissions.
Anyone know a way around this without granting extra access to data dictionary tables.