Home » RDBMS Server » Server Administration » Difference between DBA_ and ALL_ Views?
Difference between DBA_ and ALL_ Views? [message #238147] Wed, 16 May 2007 19:03 Go to next message
california_6_1
Messages: 29
Registered: February 2007
Junior Member
I was wondering, whats the difference between views starting from DBA and ALL names? I.E, dba_objects and all_objects?

Appreciated if someone please advice.

Many thanks,
Cali
Re: Difference between DBA_ and ALL_ Views? [message #238149 is a reply to message #238147] Wed, 16 May 2007 19:14 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
For a "DBA" there is NO difference.
The DBA_* show every object of that type in the database.
USER_* show only those object owned by that user.
ALL_* shows all object this user has (been granted) access to.

HTH!
Re: Difference between DBA_ and ALL_ Views? [message #238153 is a reply to message #238147] Wed, 16 May 2007 19:46 Go to previous message
california_6_1
Messages: 29
Registered: February 2007
Junior Member
Thanks a lot for your reply. It makes sense now.
Previous Topic: Connection error
Next Topic: Oracle on linux - is it free?
Goto Forum:
  


Current Time: Sat Dec 10 17:04:02 CST 2016

Total time taken to generate the page: 0.10027 seconds