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;