Home » RDBMS Server » Performance Tuning » how to give kill session priviledge to normal user
how to give kill session priviledge to normal user [message #395486] Wed, 01 April 2009 10:57 Go to next message
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.
Re: how to give kill session priviledge to normal user [message #395487 is a reply to message #395486] Wed, 01 April 2009 11:00 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can't kill your own session.



Re: how to give kill session priviledge to normal user [message #395488 is a reply to message #395486] Wed, 01 April 2009 11:00 Go to previous messageGo to next message
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
Re: how to give kill session priviledge to normal user [message #395493 is a reply to message #395486] Wed, 01 April 2009 11:14 Go to previous message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: contention on temprary tablespace
Next Topic: 'show parameter allow' doesnt work
Goto Forum:
  


Current Time: Sat Nov 02 13:39:24 CDT 2024