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@xxxxxxxxx> wrote:
>
> What about just locking the user if conditions are met ?
>
> --romas
>
>
>  On 10/12/07, Jay.Miller@xxxxxxxxxxxxxxxx <Jay.Miller@xxxxxxxxxxxxxxxx >
> 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
> >
> >
> >
> >
> >
>
>

Other related posts: