You know the all_tables view. It gives you all the tables you can access. But who doesn't ask "which are the tables user foo can access ?" and "why can he access this table".

The following view gives you for all users (column username), the owner and the name of the accessible tables (columns owner and table_name) and the origin of the access privilege (column why) with:

if the user is the owner of the table Object Priv.
if the access is via an object privilege System Priv.
if the access is via a system privilege
if the privilege or the role is granted to public
if the privilege or the role is granted to the user.

Remark: You must have the select privilege on the underlying tables.
For example, SELECT ANY TABLE in Oracle7 or 8, and SELECT ANY DICTIONARY in Oracle8i+.

Pages: 1 · 2