Home » RDBMS Server » Security » Grant to Select session details
Grant to Select session details [message #162841] Mon, 13 March 2006 17:00 Go to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Hi

Developers they use Toad and in that they want to use session browser option so that they can see the SQL running and open Cursor,other session specific details
So what grant/ permissions can be given to them so that the Schema they logged on can access those information.


Thanks

[Updated on: Mon, 13 March 2006 17:13]

Report message to a moderator

Re: Grant to Select session details [message #163010 is a reply to message #162841] Tue, 14 March 2006 09:53 Go to previous messageGo to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Hi

I got it with SELECT_CATALOG_ROLE, they can see the session details, but they are not able to trace the session, while clicking the green color (round button in Toad in session browser screen ) "trace this session" button
in the session browser
  2.1 Date   : Tue, 13 Mar 2006 09:32:58 -0600
  2.2 Address: 004E3DWW1
  2.3 Module : TOAD.exe
  2.4 Type   : EOraError
  2.5 Message: ORA-06550: line 1, column 7: PLS-00201: identifier 
'SYS.DBMS_SYSTEM' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored .



Any help what permission i am missing.


Thanks

[Updated on: Tue, 20 March 2012 13:43] by Moderator

Report message to a moderator

Re: Grant to Select session details [message #163022 is a reply to message #163010] Tue, 14 March 2006 11:08 Go to previous messageGo to next message
Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay
Member

Try with grant execute on sys.dbms_system to user.
Re: Grant to Select session details [message #163031 is a reply to message #163022] Tue, 14 March 2006 11:42 Go to previous messageGo to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Thanks All

Yes it worked with Grant Execute on sys.dbms_system to user.

In Toad after enabling a trace where can we see the output, or where can do TKprof of the trace file


Thanks

[Updated on: Tue, 14 March 2006 11:43]

Report message to a moderator

Re: Grant to Select session details [message #548200 is a reply to message #163031] Tue, 20 March 2012 13:38 Go to previous message
sssonline2
Messages: 1
Registered: March 2011
Location: Jordan
Junior Member

Thanks All
it worked for me too
Previous Topic: data encryption
Next Topic: How to edit created Security Policy (Virtual Private Database) (merged 2)
Goto Forum:
  


Current Time: Tue Jul 22 04:25:47 CDT 2014

Total time taken to generate the page: 0.14881 seconds