Search notes:

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

The following statement throws ORA-02030: can only select from fixed tables/views because V$SESSION is a synonym to V_$SESSION (as is the case for all so called V$ views):

grant select on v$session to rene;

This statement runs ok (if the grantor has admin privileges for this select right):

grant select on v_$session to rene;

An ORA-02030: can only select from fixed tables/views is also thrown for the same reason with the following revoke statement:

revoke select on v$session from rene;

This one runs ok:

revoke select on v_$session from rene;

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

See also