privileges for certain too functions

[gopi]

Which SELECT v$ tables are needed in the SESSIONS function to view detail in the 1. cursors tab 2. sql text tab 3. statistics tab 4. locks tab?

Is this listed anywhere?

I know SELECT ANY DICTIONARY works but in some cases I don't want the developer to have so much visuals into the database.

Thank you for your support,
Frank

 

[Marco Kalter]

In the Sessions window you can press the "Define Session Queries..." button. This will show the SQL text for all tab pages. You can change, add and remove queries if you want.

 

[gopi]

That was so easy!!!
Thanks.