wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 222

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.


Oracle Java Programmer , Oracle SQL Expert
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding dba_tables
 
Similar Threads
Not able to query dba_tables view
In Oracle, write SELECT query that will return metadata information for the oracle table's columns?
fetching oracle table names into java program
SQL injection?
what is the command in oracle to show databases?