Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Disconnecting session from an on logon trigger

Re: Disconnecting session from an on logon trigger

From: Roman Podshivalov <roman.podshivalov_at_gmail.com>
Date: Fri, 12 Oct 2007 16:49:19 -0400
Message-ID: <55f303590710121349r194502f4wa4f8acd5520ffd14@mail.gmail.com>


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
Received on Fri Oct 12 2007 - 15:49:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US