-
I have 4 main users in the database say oradba,spexdba,ctxsys & nfadba.
When I execute the following query from oradba, the output is
SQL> select count(*),owner from all_objects where status = 'INVALID' group by owner;
12 CTXSYS
1 NFADBA
32 ORADBA
1 SPEXDBA
When I execute the same query from ctxsys, the output is
SQL> select count(*),owner from all_objects where status = 'INVALID' group by owner;
9 ADMACS_NFA
26 CMS_NFA
1 CTXDEMO
54 CTXSYS
16 NFADBA
32 ORADBA
2 SPEXDBA
I thought all_objects view would list the objects, irrespective of whether you have access or not.
Please let me know if I am right and what is the mistake I am doing in the above queries
-
No, ALL_* family of views will report only for the objects that you own or have been given acces to. DBA_* on the other hand will list *all* the objcts in the database.