OraFAQ Forum: Forms » Killing of user sessions in oracle

Home » Developer & Programmer » Forms » Killing of user sessions in oracle (10g)

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

Killing of user sessions in oracle [message #287418]

Wed, 12 December 2007 03:46

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?

Report message to a moderator

Re: Killing of user sessions in oracle [message #287427 is a reply to message #287418]

Wed, 12 December 2007 03:57

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.

Report message to a moderator

Re: Killing of user sessions in oracle [message #288922 is a reply to message #287427]

Wed, 19 December 2007 01:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem? Search this forum for 'v$session'.

David

Report message to a moderator

Re: Killing of user sessions in oracle [message #289369 is a reply to message #288922]

Fri, 21 December 2007 00:17

mdvreddy
Messages: 17
Registered: November 2007
Location: x

Junior Member

thanks for reply. we decided not to give such permission to user.
Smile

Smile

Report message to a moderator

Re: Killing of user sessions in oracle [message #289374 is a reply to message #289369]

Fri, 21 December 2007 00:35

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Also have a look at http://www.orafaq.com/forum/t/93868/67467/

David

Report message to a moderator

Re: Killing of user sessions in oracle [message #289380 is a reply to message #289369]

Fri, 21 December 2007 01:13

Littlefoot
Messages: 21818
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.

Report message to a moderator

Previous Topic:	Getting "FRM-40105: Unable to resolve reference to item" when using FND_FUNCTION.EXECUTE i
Next Topic:	Compiling forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 08:29:04 CDT 2024