Tag Archives: How to grant access to v$ views

How to grant access to v$ views (v$session ,v$instance)

Last updated on September 2nd, 2019 at 05:52 pmOne can’t grant direct access V$session as v$session is a synonym. Same is true for v$instance In fact this is true for all the v$ views are they are all synonym’s SQL> GRANT SELECT ON v$session TO test_user; grant select on v$session to test_user * ERROR at line 1: ORA-02030: can only select from fixed tables/views Query … Continue reading How to grant access to v$ views (v$session ,v$instance) »