Difference between USER_TABLES, ALL_TABLES and DBA_TABLES

posted Mar 31, 2011, 11:07 AM by Sachchida Ojha
USER_TABLES is tables which you own
ALL_TABLES is tables which own, and tables owner by other users, which you have been granted excplicit access to
DBA_TABLES is all tables in the database

All three are views of the underlying SYS tables, but the USER_ and ALL_ views joing in your username/security info to limit the results
Comments