Wednesday, September 12, 2012

Oracle DB monitor session. ORA-00942: table or view does not exist

apparently you need to have SYS

"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: