Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Disconnecting session from an on logon trigger
You might look at enabling and disabling restricted session.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of sol beach
Sent: Friday, October 12, 2007 5:16 PM
To: roman.podshivalov_at_gmail.com
Cc: Jay.Miller_at_tdameritrade.com; oracle-l_at_freelists.org
Subject: Re: Disconnecting session from an on logon trigger
see this thread
http://www.orafaq.com/forum/m/270601/74940/?srch=logon+trigger#msg_27060 1
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 <http://9.2.0.7/>
Thanks,
Jay Miller
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 15 2007 - 08:04:54 CDT
![]() |
![]() |