Oracle: How can I see what tables I have access to and what tables I own?

Answer 1

Oracle Data Dictionary provides 3 levels of views user,all and dba views.

These views provide information based on your privileges in the database.

User_tables, User_indexes.. etc., provide information about the objects you own.

All_Tables, All_indexes... etc., provide information about the objects you have access to.

Dba_tables, dba_indexes.. etc., provide information about all the objects in the database but are only available to dba's.

Example :

To see what tables I own...

select table_name from user_tables;

To see what tables I have access to and who the owner is...

select owner, table_name from user_tables;