Retrieval of Role granted by 1 user to an other user

Hi...

I would like to retrieve roles granted by a user to some other user. Any idea which data dictionary tables will give me the grantee and the reciever of the roles that this particular user has granted.

No other roles/ users should be picked up.

The SQL has to run for the logged on DBA user

If User A
grants Role R1 to User B
I would like to retrieve the role that B has got from A. ie : R1 Logged on User A


Thanks in Advance

No, you can't get who granted a particular role to a particulaar user. It is not recorded in a database dictionary. If you need to track that information then you'll have to turn on auditing on SYSTEM GRANT and get the information you need from audit trail.