I am trying to fully understand the difference between ALL_OBJECTS and DBA_OBJECTS. I am still new in Oracle and get confused by the whole Access/Roles thing.
- ALL_OBJECTS shows all objects of current and those object which you have rights to access.
- DBA_OBJECTS shows all object of all users .
My question is, if you have DBA role, should ALL_OBJECTS be equal to DBA_OBJECTS? I have DBA role and in the Database I am working on and ALL_OBJECTS returns fewer elements than DBA_OBJECTS.
If I have DBA Role shouldn't I have access to all the objects in DBA_OBJECTS and therefore both views should be equal?