ORA-00904: : invalid identifier while accessing view from any other user except for owner and sys ac

Hi All,

I need help..in resolving one issue while accessing view on production database oracle version 10.2.0.4.

SQL> show user
USER is "ETH_CDLRPT"

SQL>  select count(*) from eth_cdlrpt.v_ctr;
 select count(*) from eth_cdlrpt.v_ctr
                                     *
ERROR at line 1:
ORA-00904: : invalid identifier

SQL> select count(*) from eth_cdlrpt.v_ctr where 1=1;

  COUNT(*)
----------
     28998
Select privelege is giving with grant option and base tables of the view are also accessible.

Regards

Hemanti