Re: Disconnecting session from an on logon trigger

see this thread
http://www.orafaq.com/forum/m/270601/74940/?srch=logon+trigger#msg_270601

Exactly what are the "certain circumstances"?

I suspect the desired solution is a case where it is the wrong tool for this job

On 10/12/07, Roman Podshivalov <roman.podshivalov_at_gmail.com> wrote:
>
> What about just locking the user if conditions are met ?
>
> --romas
>
>
> On 10/12/07, Jay.Miller_at_tdameritrade.com <Jay.Miller_at_tdameritrade.com >
> wrote:
> >
> > I'd like to create an on logon trigger that will prevent the user from
> > connecting in certain circumstances. I have one way of doing it which would
> > be to issue
> > execute immediate ' alter system kill session 'session_id', 'serial#''
> >
> > but I can't help but wonder if there's a cleaner way to do it from
> > within oracle instead of killing the session?
> >
> >
> >
> > Oracle 9.2.0.7
> >
> >
> >
> > Thanks,
> > Jay Miller
> >
> >
> >
> >
> >
>
>

--
http://www.freelists.org/webpage/oracle-l