While providing select privilege on a v$ view , you may get below error.

 

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

 

Problem:

SQL> grant select on v$session to test;
grant select on v$session to test
                *
ERROR at line 1:
ORA-02030: can only select from fixed tables/views

Solution:

You need to replace v$ with v_$ i.e it should be v_$session.

SQL> grant select on v_$session to test;

Grant succeeded.