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.
