Re: allowing a user to kill his own connections

From: Ana C. Dent <>
Date: Tue, 06 May 2008 03:00:22 GMT
Message-ID: <Xns9A95CB4A54936anacedenthotmailcom@> wrote in news:NsKTj.1754$

> 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

Original text of this message