Re: allowing a user to kill his own connections
Date: Tue, 06 May 2008 03:00:22 GMT
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