oraclespin.com
How to grant SELECT access to v$session to other users?
One can’t grant direct access V$session as v$session is a synonym. SQL> GRANT SELECT ON v$session TO scott; grant select on v$session to test * ERROR at line 1: ORA-02030: can only select …