OraFAQ Forum: Security » Grant to Select session details

Home » RDBMS Server » Security » Grant to Select session details

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grant to Select session details [message #162841]

Mon, 13 March 2006 17:00

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

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

Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay

Member

Try with grant execute on sys.dbms_system to user.

Report message to a moderator

Re: Grant to Select session details [message #163031 is a reply to message #163022]

Tue, 14 March 2006 11:42

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

sssonline2
Messages: 1
Registered: March 2011
Location: Jordan

Junior Member

Thanks All
it worked for me too

Report message to a moderator

Previous Topic:	data encryption
Next Topic:	How to edit created Security Policy (Virtual Private Database) (merged 2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 21:27:07 CST 2025