Re: allowing a user to kill his own connections

mh_at_pixar.com wrote in news:NsKTj.1754$ah4.1745_at_flpi148.ffdc.sbc.com:

> 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. Received on Mon May 05 2008 - 22:00:22 CDT