No. However, it is pretty simple to put together a stored procedure
that will be owned by a user that has the ability to kill any session
and to then grant execute access on that stored procedure to the users.
Within the stored procedure, you can check whatever you would like (i.e.
same user) and do whatever logging would be appropriate.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Trenta Lorenzo
[mailto:oracledba-ezmlmshield-x35001601.[Email address protected]
Sent: Thursday, March 03, 2005 1:59 AM
To: LazyDBA Discussion
Subject: owner session
Hi,
I have a question.
I must give permission that the client can kill owner session (in
particular owner running statement).
Exist a permisione for this ?
Thanks
Lorenzo
--- INIZIO DISCLAIMER --------------------------------------------------
Questo messaggio (inclusi tutti gli eventuali allegati) contiene
informazioni di natura confidenziale ed e' indirizzato ai soli
destinatari a cui fa esplicito riferimento. Se non siete nella lista dei
destinatari vogliate p.f. astenervi dal divulgare, distribuire, copiare
o utilizzare il contenuto di questo messaggio. Se avete ricevuto questo
messaggio per errore, vogliate cortesemente darne immediata notifica,
via e-mail, al mittente provvedendone poi alla cancellazione da tutti i
vostri sistemi.
--- FINE DISCLAIMER ----------------------------------------------------
--- BEGIN OF DISCLAIMER ------------------------------------------------
This message (including any attachments transmitted with it) contains
confidential information and is intended only for the individual named
herein. If you are not the herein named addressee you should not
disseminate, distribute, copy or otherwise make use of this message.
Please notify the sender immediately by e-mail if you have received this
message by mistake, and delete it from your systems.
--- END OF DISCLAIMER --------------------------------------------------
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page