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 |
|
|