On May 6, 11:55=A0pm, m...@[EMAIL PROTECTED]
wrote:
> Ana C. Dent <anaced...@[EMAIL PROTECTED]
> wrote:
>
> > m...@[EMAIL PROTECTED]
wrote innews:NsKTj.1754$ah4.1745@[EMAIL PROTECTED]
>
> > > I would like to allow developers to kill their own sessions, e.g.
>
> > > =A0 =A0 alter system kill session '$sid,$serial#'
>
> > > but only for sessions which are theirs.
>
> > > Is there a grant which can handle this? =A0If 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.
>
> And if I want to make sure that you can't kill someone else's
> session, that should be handled by comparing the current
> user with the user of the $sid, is that right?
>
> In other words, there's not an automatic owner****p/protection
> mechanism a la unix processes and kill.
>
> Thanks All!
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios
You are correct.
David Fitzjarrell
|
