OraFAQ Forum: SQL & PL/SQL » Difference between all_tables and dba

Home » SQL & PL/SQL » SQL & PL/SQL » Difference between all_tables and dba_tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference between all_tables and dba_tables [message #30443]

Fri, 30 April 2004 03:52

lalitha
Messages: 39
Registered: June 2002

Member

Hi

Is there any�difference between all_tables and dba_tables? (as both of these objects has same structure)

Lalitha

�

�

Report message to a moderator

Re: Difference between all_tables and dba_tables [message #30447 is a reply to message #30443]

Fri, 30 April 2004 04:14

Srinath
Messages: 40
Registered: May 2002

Member

Hi:

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.

Thank you.
Srinath

Report message to a moderator

Re: Difference between all_tables and dba_tables [message #30451 is a reply to message #30443]

Fri, 30 April 2004 04:42

shoblock
Messages: 325
Registered: April 2004

Senior Member

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 (the original VPD).

Report message to a moderator

Re: Difference between all_tables and dba_tables [message #30456 is a reply to message #30447]

Fri, 30 April 2004 07:03

Sud
Messages: 63
Registered: September 2002

Member

To be more clearer, all_tables shows you only the tables those are allowed for your previliges, where the dba_tables shows all the tables as dba is allowed view/change/delete any of them.
Hope this helps. Good luck :)

Report message to a moderator

Re: Difference between all_tables and dba_tables [message #30466 is a reply to message #30443]

Sat, 01 May 2004 15:38

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

Just for fun, did you look at DBA_ALL_TABLES?

Report message to a moderator

Previous Topic:	query while picking from excel?
Next Topic:	which stmt. is better & why ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 18 05:41:22 CDT 2025