Return
-
Title
What views or other objects are required to use Session Browser? -
Description
What views or other objects are required to use Session Browser?
-
Resolution
Here is a list of objects you need select privileges on to use Toad's Session Browser. You can look this up under Help | Contents under the “V$ Tables Required” topic.
Toad Session Browser
The following public synonyms must be present:
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$SQLTEXT_WITH_NEWLINES
In addition, you must have access to the following:
SYS.V_$TRANSACTION
SYS.V_$ROLLNAME