Grants for "Tools > Sessions"

[MarcusRangel]

Dear Friends,

Does anybody have the list of grants needed for a user to execute all the queries run by the "Tools > Sessions" option ?

TIA,
Rangel

 

[Kirurgs]

For main window:
v$sesison

For information in tabs:
v$open_cursor
v$sqltext_with_newlines
v$sesstat
v$statname
v$lock
sys.all_objects

 

[Marco Kalter]

You can also see the actual queries by pressing the "Define Session Queries" button on the toolbar of the Sessions Window.

 

[BushPilot]

What other V$ views/tables is used in the product? We need to restrict/ revoke select any table from all users/devellopers.
This now results in an ora-942 when they expand the browser.

 

[Marco Kalter]

Besides for the v$ views in the Session Window, the "Automatic Statistics" requires select privileges on the v$session, v$sesstat, and v$statname views. If a user does not have these privileges, the statistics are disabled.