Q

Difference between ALL_OBJECTS and DBA_OBJECTS

Can you tell me what is the difference between ALL_OBJECTS and DBA_OBJECTS?

One needs to understand how the data dictionary is structured. There are USER_* views, ALL_* views, and DBA_* views. USER_* views are views on those things that the current user owns. ALL_* views are views on those things that the current user owns, and has privileges to access. DBA_* views are views on all things in the database. So USER_OBJECTS lists just the objects owned by the current user. ALL_OBJECTS lists all the objects owned by the current user and those objects the current user has access to. DBA_OBJECTS lists every single object in the database.

This was first published in October 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close