Child pages
  • How to grant select on Oracle performance views
Skip to end of metadata
Go to start of metadata

These privileges are required to use the "Monitor SQL" feature of SQL Developer:


create role dynamic_views;

grant select on v_$session to dynamic_views; 
grant select on v_$database to dynamic_views; 
grant select on v_$lock to dynamic_views;
grant select on v_$sql to dynamic_views; 

grant dynamic_views to <user>;