aspose file tools*
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
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: 319

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding dba_tables