How to grant access to v$ views

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

June 15, 2020 by techgoeasy Leave a Comment

One 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 […]