This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Regarding dba_tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Regarding dba_tables" Watch "Regarding dba_tables" New topic
Author

Regarding dba_tables

Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 339

The structure of dba_tables and all_tables is same and the results are also same when you connect as a DBA user. (DBA role granted user).

Where as you cannot view dba_tables with out having dba role. you can view user_tables and all_tables with normal user privilege. Here you will see the difference. The all_tables return only the user specific table The structure is same and the results are also same when you connect as a DBA user. (DBA role granted user).

Where as you cannot view dba_tables with out having dba role. you can view user_tables and all_tables with normal user privilege. Here you will see the difference. The all_tables return only the user specific tables.


http://www.mahtabalam.net , Oracle Java Programmer , Oracle SQL Expert , Oracle Java Web Component Developer
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Regarding dba_tables