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

I want to grant the user ability to select from v$session. so I issue the GRANT SELECT ON v$session TO rcs1; However, I got the ORA-02030: can only select from fixed tables/views

It turns out I have to grant the V$SESSION is just SYNONYM. when you query the dba_objects table, the object name must be UPPER CASE.

SELECT owner, object_type FROM dba_objects WHERE object_name = 'V$SESSION';

The actual table for the v$session is V$_session.

select table_owner, table_name FROM dba_synonyms where synonym_name = ‘V$SESSION’;

Lets try to grant the permission again.

GRANT SELECT ON V_$SESSION TO rsc1;