PC Section

by sagar.

Saturday, April 25, 2015

Oracle :Difference between all_objects,user_objects,dba_objects

Hi Friends,
After a long time i got interest to write something and today's containt for Database.
Table sturcture which is not defined in DB-user but in schema. it's related to user also.

Difference b/w  all_object ,user_object, dba_objects

all_objects is show you all objects of current and those object which you have rights to access.
dba_objects show all object of all users.

user_objects show you the current user objects.