Difference between user_objects, all_objects and dba_objects

Difference between those views is;

  • USER_OBJECTS shows the current user objects.
  • ALL_OBJECTS shows all objects of current and those object which you have rights to access.
  • DBA_OBJECTS shows all object of all users .

Lets generalize this valuable information. It is applicable to every user_<blabla>, all_<blabla>, dba_<blabla> views.

I got this information here. But a wise man one said.

“Repeat the real truth wherever it is needed, altough its not revealed by you”

Dont ask me who was this guy. Never saw him.