RE: kill session privilege

At 01:24 AM 1/14/2004, Mark Richard wrote:

>I imagine the reason goes something along the lines of "Sometimes
>developers fire off queries that are going to run for an exceptionally long
>time, often accidentally" If you are only talking about killing sessions
>on a development machine then I think it's a fairly valid request - I can't
>imagine why a developer would ever want to kill a production session.

Well, sometimes developers are asked to generate ad-hoc reports for management. In those cases, it's pretty easy to accidentally generate the "query from heck" and need to kill it.

>The earlier suggestion of writing a procedure and granting execute rights
>on that procedure is an approach I have heard of before.

What I've generally seen is a stored procedure that checks to make sure that the session the user is trying to kill is their own, probably logs the kill in some sort of audit table, etc. I don't have much of a problem with a developer killing their own session even in production.

Justin Cave

>
>
> "Goulet,
> Dick"
>
> <DGoulet_at_vicr.com To: Multiple
> recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > cc:
>
> Sent by: Subject: RE: kill session
> privilage
> ml-errors_at_fatcity
>
> .com
>
>
>
>
>
> 14/01/2004
> 08:44
>
> Please respond
> to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
>First question for the boss, WHY?
>
>
>
>Dick Goulet
>Senior Oracle DBA
>Oracle Certified 8i DBA
>
>
> -----Original Message-----
> From: AK [mailto:oramagic_at_hotmail.com]
> Sent: Tuesday, January 13, 2004 2:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: kill session privilage
>
> My boss want me to give kill session privilage one of the developer
> here . He doesn't have any dba privilage to see session or anything .
> Is there any way I can give likited access to him.
>
> Thanks,
> ak
>
>
>
>
>
><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>Privileged/Confidential information may be contained in this message.
>If you are not the addressee indicated in this message (or responsible for
>delivery of the message to such person), you may not copy or deliver this
>message to anyone.
>In such a case, you should destroy this message and kindly notify the
>sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999.
>Please advise immediately if you or your employer does not consent to
>Internet e-mail for messages of this kind.
>Opinions, conclusions and other information in this message that do not
>relate to the official business of Transurban Infrastructure Developments
>Limited and CityLink Melbourne Limited shall be understood as neither
>given nor endorsed by them.
><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Mark Richard
> INET: mrichard_at_transurban.com.au
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Justin Cave
  INET: jcave_at_cableone.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).