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.