OraFAQ Forum: Performance Tuning » how to give kill session priviledge to normal user

Home » RDBMS Server » Performance Tuning » how to give kill session priviledge to normal user

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

how to give kill session priviledge to normal user [message #395486]

Wed, 01 April 2009 10:57

rituraj
Messages: 18
Registered: April 2009
Location: INDIA

Junior Member

hi
i want to give one of my user to kill his own session privilege.
how is it possible. i also dont want that user to make any changes except to kill his own session and want to keep my database secure.
thank you.

Report message to a moderator

Re: how to give kill session priviledge to normal user [message #395487 is a reply to message #395486]

Wed, 01 April 2009 11:00

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

You can't kill your own session.

Report message to a moderator

Re: how to give kill session priviledge to normal user [message #395488 is a reply to message #395486]

Wed, 01 April 2009 11:00

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:226613885088

Report message to a moderator

Re: how to give kill session priviledge to normal user [message #395493 is a reply to message #395486]

Wed, 01 April 2009 11:14

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

i want to give one of my user to kill his own session privilege.

Why not just "disconnect"?

Regards
Michel

Report message to a moderator

Previous Topic:	contention on temprary tablespace
Next Topic:	'show parameter allow' doesnt work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 11:01:34 CST 2025