Toad World® Forums

Session Browser


#1

what tables do you need access to for this to work?

I get errors like “table or view does not exist” when I try to use it.

thanks,

Jet


#2

Hi Joe,

Which tab in the Session Browser was you on?

Gwen


#3

Multiple, the only one I can get to is session. I need to make a request to our DBAs to give me access, but I want to know what tables/views to ask for.


#4

Hi Joe,

I have a user which only has Connect Role. I tried to use session browser with it and it gave me the same error as you did. It also said ‘you dont have privilege to access v$session’. Maybe that’s the key. I also noticed that if it has the resource role, it can also use session browser. Hope this helps.

Gwen


#5

Seems to me that Quest should publish the list of tables you need access to to run this feature since it accesses v$ tables that are, often, not accessible to the average developer.

Do you have a complete list? I’d hate to have to ask twice and annoy the DBAs. You know how they can get! :wink:

Jet


#6

Jeff will get back to you on this later today.

Cheers
Gwen


#7

Hi Jet,

Here is the list:

DBA_ROLLBACK_SEGS
V$ACCESS
v$lock
v$locked_object
V$MYSTAT
v$open_cursor
V$PROCESS
v$px_process
v$px_sesstat
V$SESS_IO
V$SESSION
v$session sess
v$session_event
v$Session_longops
v$session_wait
v$sql
V$SQLTEXT_WITH_NEWLINES
v$statname

Thanks,
Bruce