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

[rahulrathod]

All,

I create a synonym on my dev without any errors as follows.

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

SQL> grant select on session_users to ecrf_user;
grant succeeded

But on Test env., I get the following errors

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

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