Session browser - what privileges are needed?

[dcookie]

Can anyone tell me what sys tables/views I need access to in order to get the session browser tabs for cursors, sql text, etc. to populate correctly? I get the list of sessions correctly, but the tabs show ora-00942.

Thanks.

----dale

 

[dcookie]

Okay, after chasing this down for a while, I've come up with the privileges necessary for each of the tabs in the session tool (10g R2):

Main window: v_$session
Cursors tab: v_$open_cursor
SQL Text tab: v_$sqltext_with_newlines
Statistics tab: v_$sesstat and v_$statname
Locks tab: v_$lock

It would be nice if the documentation contained info like this for anyplace where out-of-the-box Oracle permissions are inadequate, rather than assuming everyone who runs the program has the DBA role. Hopefully this will save someone else an hour or two of sifting thru the dynamic tables in oracle...

---dale

 

[Marco Kalter]

If you press the "Define Session Queries" button on the Session Window toolbar, you can see the queries that are used for the session filters and the session details. This way you can determine which privileges are required.