Users accessing multiple schemas

We have data mart and data warehouse under one instance. Some users user DM (DM has multiple schemas) and some users use DW (one schema) and some users access objects from both (DW and DM). Can someone please let me know the best way to find what objects/schemas each user has access to or is allowed to (10g database)? I have 171 users defined.

Thanks in advance!

Vpons

Try:

{ALL|DBA}_TAB_PRIVS
DBA_ROLE_PRIVS
:rolleyes:
Which you could found out yourself if you have read the fine Oracle Database Reference Manual.