Write a procedure that kills the relevant session(s) and grant the user execute access to that procedure.
-----Original Message-----
From: ef 8454 [mailto:[EMAIL PROTECTED]]
Sent: mardi, 25. septembre 2001 15:30
To: Multiple recipients of list ORACLE-L
Subject: [Q] privilege allow user kill session???
We have ORACLE 8.1.6 on UNIX server. My users asked me grant him the right to "kill the run away session." I don't want grant "alter
system," alter system kill ..., to him; Because it is too high
privilege. Does their has any other privilege which allow user kill
session?