jeudi 8 janvier 2015

Are the ALL_OBJECTS and DBA_OBJECTS different when you have DBA Role?


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.


From here:



  • 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?





Aucun commentaire:

Enregistrer un commentaire