apparently you need to have SYS
https://forums.oracle.com/forums/thread.jspa?threadID=714957
"What roles does your user have? (One way to find out is to do a "SELECT * FROM SESSION_ROLES;" in the SQL Worksheet or SQL*Plus.) The "Monitor Sessions" tool runs a query against the V$SESSION dynamic view and according to the Oracle 10g Database Reference document only user SYS or users with the SYSDBA role have access to the dynamic views.
I just tried using "Monitor Sessions" while connected as a user who has only the CONNECT and RESOURCE roles and got the ORA-00942 error. I connected as another user who has the DBA role and it ran without a problem."
No comments:
Post a Comment