Re: allowing a user to kill his own connections
From: <fitzjarrell_at_cox.net>
Date: Tue, 6 May 2008 05:21:43 -0700 (PDT)
Message-ID: <3e016137-fa19-43c2-8be4-44d318f94f84@w7g2000hsa.googlegroups.com>
Date: Tue, 6 May 2008 05:21:43 -0700 (PDT)
Message-ID: <3e016137-fa19-43c2-8be4-44d318f94f84@w7g2000hsa.googlegroups.com>
On May 5, 3:53 pm, m..._at_pixar.com wrote:
> 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?
>
> TIA!
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios
I agree with the stored procedure route, as that's the only way you could restrict the action to sessions associated with the invoking user.
David Fitzjarrell Received on Tue May 06 2008 - 07:21:43 CDT