Home » Developer & Programmer » Forms » Killing of user sessions in oracle (10g)
Killing of user sessions in oracle [message #287418] Wed, 12 December 2007 03:46 Go to next message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
We need to allow user/schema to kill his own sessions that he/her already opened which are running abnormally from the session he newly opened (same schema). Is it possible? if yes, any grants need to granted to that user from DBA ? Could you please help me?
Re: Killing of user sessions in oracle [message #287427 is a reply to message #287418] Wed, 12 December 2007 03:57 Go to previous messageGo to next message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
clearly:

Is there any way to kill one Oracle'session of a user, connecting with the same user?. this user is not supposed to kill any other users oracle sessions except his own oracle'sessions. Please advice.
Re: Killing of user sessions in oracle [message #288922 is a reply to message #287427] Wed, 19 December 2007 01:11 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem? Search this forum for 'v$session'.

David
Re: Killing of user sessions in oracle [message #289369 is a reply to message #288922] Fri, 21 December 2007 00:17 Go to previous messageGo to next message
mdvreddy
Messages: 17
Registered: November 2007
Location: x
Junior Member
thanks for reply. we decided not to give such permission to user.
Smile
Re: Killing of user sessions in oracle [message #289374 is a reply to message #289369] Fri, 21 December 2007 00:35 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Also have a look at http://www.orafaq.com/forum/t/93868/67467/

David
Re: Killing of user sessions in oracle [message #289380 is a reply to message #289369] Fri, 21 December 2007 01:13 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
mdvreddy wrote on Fri, 21 December 2007 07:17

We decided not to give such permission to user.

Sounds like a good decision; not everyone should be granted a licence to kill.
Previous Topic: Getting "FRM-40105: Unable to resolve reference to item" when using FND_FUNCTION.EXECUTE i
Next Topic: Compiling forms
Goto Forum:
  


Current Time: Sat Dec 03 00:51:58 CST 2016

Total time taken to generate the page: 0.08926 seconds