Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: kill his sessions
astalavista wrote:
> Hi,
>
> What role/privilege can I give to a user
> so he can kill his own sessions ? and not the others
> alter session seems too much to me , no ?
>
> Thanks in advance ...
Depends on the situation. As Mark indicates one answer is ALTER SYSTEM. On the other hand if the user has access to the server then KILL or ORAKILL can be used.
Rather than granting the privilege it is safer to write a stored procedure, owned by a DBA account, that allows users to kill their own, and ONLY their own, sessions.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu May 11 2006 - 16:49:29 CDT