In Enterprise Manager, I can look at all permissions granted to a particular role, broken out by user/object. To do this I double-click on the role, then choose "List only objects with permissions for this role"
How do I do the same thing using SQL?
Eagerly awaiting your expertise,
Dana