ORA-02030: can only select from fixed tables/views

[rahulrathod]

Please help me get a solution for the following error. I execute the following on my Dev environment as sys.

SQL> CREATE PUBLIC SYNONYM session_users FOR v$session ;
Synonym created.

SQL> grant select on session_users to ecrf_user;
grant succeeded.

The same statements give an error on the Test environment.

SQL> CREATE PUBLIC SYNONYM session_users FOR v$session ;
Synonym created.

SQL> grant select on session_users to ecrf_user;
grant select on session_users to ecrf_user
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views

Please help. thanks.

Rahu.