Lee,
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.
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.
HTH,
Gary
Weber
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of lerobe - Lee Robertson
Sent: Tuesday, April 17, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Subject: Ability for non DBA user to kill session.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of lerobe - Lee Robertson
Sent: Tuesday, April 17, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Subject: Ability for non DBA user to kill session.
All,
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.
Oracle
8.0.5.0.0
Compaq Tru64
4.0f
Regards
Lee
Lee Robertson
Acxiom
Tel:
0191 525 7344
Fax:
0191 525 7007
Email:
[EMAIL PROTECTED]
The information contained in this
communication is
confidential, is intended only for the use of the
recipient
named above, and may be legally privileged. If the reader
of
this message is not the intended recipient, you are
hereby notified that any
dissemination, distribution or
copying 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 computer
system.