Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ability for non DBA user to kill session.
<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
![]() |
![]() |