OraFAQ Forum: Server Administration » Difference between DBA_ and ALL

Home » RDBMS Server » Server Administration » Difference between DBA_ and ALL_ Views?

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

Difference between DBA_ and ALL_ Views? [message #238147]

Wed, 16 May 2007 19:03

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

Report message to a moderator

Re: Difference between DBA_ and ALL_ Views? [message #238149 is a reply to message #238147]

Wed, 16 May 2007 19:14

BlackSwan
Messages: 26766
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!

Report message to a moderator

Re: Difference between DBA_ and ALL_ Views? [message #238153 is a reply to message #238147]

Wed, 16 May 2007 19:46

california_6_1
Messages: 29
Registered: February 2007

Junior Member

Thanks a lot for your reply. It makes sense now.

Report message to a moderator

Previous Topic:	Connection error
Next Topic:	Oracle on linux - is it free?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 18 04:31:58 CDT 2026