Home » RDBMS Server » Security » Kill Session privileges
Kill Session privileges [message #243155] Wed, 06 June 2007 04:45 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
I create one user having the privileges of create session

kindly suggest what privileges is required to this user to kill a session. This user should have privileges of kill session only
he should n't do any activity except create session & kill session.


Regards


Tarun Mittal


Re: Kill Session privileges [message #243162 is a reply to message #243155] Wed, 06 June 2007 05:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The privilege is ALTER SYSTEM but if you only want to allow him to kill session, you have to create a procedure to do this and grant him the privilege to execute it.

Regards
Michel
Re: Kill Session privileges [message #243165 is a reply to message #243162] Wed, 06 June 2007 05:16 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Can u give that procedure? if u have

PLZ....


Regards

Tarun Mittal
Re: Kill Session privileges [message #243174 is a reply to message #243165] Wed, 06 June 2007 06:00 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just enclose the statement "alter system kill session" in the procedure.
Could you try it?

Regards
Michel
Previous Topic: LOGON vs. LOGOFF during auditing
Next Topic: securing ur tables
Goto Forum:
  


Current Time: Thu Mar 28 14:11:11 CDT 2024