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