Query to obtain usernames and the tables that can be selected by that user

All -

Would you know of a well-performing query that lists individual Oracle usernames and the tables and views that that user can select from? Obviously, a user can select from a given table via a direct grant on the table/view to the user or via a grant to appropriate role(s).

Assume that the user executing this query has DBA privilege.

I'm sure that I could get this to work on my own, but all of the references to all_tab_privs, dba_roles, dba_role_privs, etc. is making my head hurt. I was hoping that someone had done something similar to this before.

If you know of such a query, could I borrow it from you?

Many thanks,
Tom Received on Fri Jan 24 2003 - 14:32:08 CST