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