RE: [Q] privilege allow user kill session???

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Tue, 25 Sep 2001 15:15:45 -0700
Message-ID: <F001.003986CD.20010925151600@fatcity.com>

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: Bruce.Reardon_at_comalco.riotinto.com.au

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: ListGuru_at_fatcity.com (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). Received on Tue Sep 25 2001 - 17:15:45 CDT