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

 

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

 

Problem:

Solution:

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