What SYS table rights does the Session Browser need?
The Session Browser needs the following tables
V$SESSION
V$PROCESS
V$SESS_IO
V$SESSION_WAIT
V$SESSION_EVENT
V$ACCESS
V$SESSSTAT
V$STATNAME
V$OPEN_CURSOR
V$SQL
V$LOCK
V$SESSION_LONGOPS
V$TRANSACTION
V$ROLLNAME
V$SQLTEXT_WITH_NEWLINES
V$EVENTMETRIC
V$EVENT_NAME
If rights to the listed tables are granted and you still cannot access the Session Browser, please run a SQL Monitor session to determine what other tables are missing.
1. Start Toad and go to Database | Monitor | SQL Monitor
2. In SQL Monitor session, check the toad.exe check box
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center