Hello,
I have Developers who want to use the Monitor Session features in SQL Developer. I have created a role named browse_session_role and assigned these privs:
grant select on SYS.V_$PROCESS to browse_session_role;
grant select on SYS.V_$SESSION to browse_session_role;
grant select on SYS.V_$TRANSACTION to browse_session_role;
grant select on SYS.V_$SESSION_LONGOPS to browse_session_role;
grant select on SYS.V_$LOCK to browse_session_role;
grant select on SYS.V_$SESSTAT to browse_session_role;
grant select on SYS.V_$STATNAME to browse_session_role;
grant select on SYS.V_$ACCESS to browse_session_role;
grant select on SYS.V_$ROLLNAME to browse_session_role;
grant select on SYS.V_$SQLTEXT_WITH_NEWLINES to browse_session_role;
grant select on SYS.V_$SQL to browse_session_role;
grant select on SYS.V_$OPEN_CURSOR to browse_session_role;
grant select on SYS.V_$SESSION_WAIT to browse_session_role;
grant select on SYS.V_$SESSION_EVENT to browse_session_role;
grant select on SYS.V_$SESSION_CONNECT_INFO to browse_session_role;
grant select on SYS.V_$EVENT_NAME to browse_session_role;
grant select on SYS.V_$SESS_IO to browse_session_role;
grant select on SYS.V_$EVENTMETRIC to browse_session_role;
grant select on SYS.DBA_ROLLBACK_SEGS to browse_session_role;
Still getting the ORA-00942 error when trying to run the Monitor Sessions.
I have read that the solution is to grant the user the select_any_dictionary privilege and be done with it. I have concerns about the wisdom of that ... Comments anyone ???
Questions:
1. Will Monitor Sessions work with a homegrown role ?
2. if so, what additional grants am I missing?
3. if not, is granting select_any_dictionary the only and best solution ?
Much thanks
catharine