Tuesday, June 9, 2015

Difference between ALL_OBJECTS and DBA_OBJECTS

Difference between ALL_OBJECTS and DBA_OBJECTS
·         USER_OBJECTS lists the objects owned by the current user i.e. User you have logged in
·         ALL_OBJECTS lists all the objects owned by the current user and those objects the current user has access to.
·         DBA_OBJECTS lists all objects in the database.

No comments:

Post a Comment