Re: Disconnecting session from an on logon trigger

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