Re: allowing a user to kill his own connections

mh@[EMAIL PROTECTED]
 wrote in news:NsKTj.1754$ah4.1745@[EMAIL PROTECTED]
> I would like to allow developers to kill their own sessions, e.g.
> 
>     alter system kill session '$sid,$serial#'
> 
> but only for sessions which are theirs.
> 
> Is there a grant which can handle this?  If not, what's the
> best way to handle this?
> 

You can write a procedure owned by SYS which can issue the ALTER SYSTEM;
using owner's rights not invoker's rights.