all_objects issue

[Umesh_Shar]

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

[jmodic]

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.