Hi,
You could create a procedure / package that does a kill session (taking the
sid,serial number as parameters) and then grant execute on that procedure to
the user.
Doing this, you could limit the privilege to only allow users to kill their
own run away sessions.
Take care, as you don't want the user killing off background processes, nor
do you probably want them to be able to kill off other user's sessions.
HTH,
Bruce Reardon
-----Original Message-----
Sent: Wednesday, 26 September 2001 8:30
To: Multiple recipients of list ORACLE-L
We have ORACLE 8.1.6 on UNIX server. My users asked me grant him the right
to "kill the run away session." I don't want grant "alter
system," alter system kill ..., to him; Because it is too high
privilege. Does their has any other privilege which allow user kill
session?
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
