File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regarding dba_tables

 
Mahtab Alam
Ranch Hand
Posts: 391
1
Java MySQL Database PHP
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic