ORA-02030 - Grants on v$ views

Today I have faced an issue while giving GRANT permission on a v$ view. Received 'ORA-02030: can only select from fixed tables/views' error.

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

SQL>

Solution:

Here the problem is caused because of trying to give select privilege on a synonym, Oracle v$ views are named V_$VIEWNAME and they have synonyms in format V$VIEWNAME and we can't give any privilege on a synonym.

If you want to give permission to a V$ views, Follow below way,,

SQL> grant select on v_$session to TEST_SUH;

Grant succeeded.