Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ability for non DBA user to kill session.

RE: Ability for non DBA user to kill session.

From: Gary Weber <gweber_at_cji.com>
Date: Tue, 17 Apr 2001 09:13:09 -0700
Message-ID: <F001.002EAF08.20010417091524@fatcity.com>

<FONT face=Arial color=#0000ff

size=2>Lee,
<FONT face=Arial color=#0000ff

size=2> 
In
short, you can't achieve this within Oracle domain short of granting ALTER SYSTEM to user in question or going via PL/SQL procedure owned by other, more protected schema.
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>However, a tool like TOAD will provide similar capability for you - a user is capable to "cancel" long running queries. I'm guessing that is the desired goal in any case.
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>HTH,
<FONT face=Arial color=#0000ff

size=2> 
Gary
Weber
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Tahoma

size=2>-----Original Message-----From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of lerobe - Lee RobertsonSent: Tuesday, April 17, 2001 11:26 AMTo: Multiple recipients of list ORACLE-LSubject: Ability for non DBA user to kill session.
<SPAN

class=078202314-17042001>All,
<SPAN

class=078202314-17042001> 
Is there a method
for allowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user.
<SPAN

class=078202314-17042001> 
Oracle
8.0.5.0.0
Compaq Tru64
4.0f
<SPAN

class=078202314-17042001> 
<SPAN

class=078202314-17042001>Regards
<SPAN

class=078202314-17042001> 
<SPAN

class=078202314-17042001>Lee
Lee Robertson <FONT face=Arial
color=#0000ff>Acxiom Tel:
   0191 525 7344 Fax:
   0191 525 7007 Email:
lerobe_at_acxiom.co.uk
 The information contained in this
communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem. Received on Tue Apr 17 2001 - 11:13:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US