RE: Disconnecting session from an on logon trigger
- From: <Jay.Miller@xxxxxxxxxxxxxxxx>
- To: <sol.beach@xxxxxxxxx>, <roman.podshivalov@xxxxxxxxx>
- Date: Tue, 16 Oct 2007 11:15:18 -0400
The circumstances is to prevent someone from logging in for a specific
module.
Jay Miller
Sr. Oracle DBA
201.369.8355
________________________________
From: sol beach [mailto:sol.beach@xxxxxxxxx]
Sent: Friday, October 12, 2007 6:16 PM
To: roman.podshivalov@xxxxxxxxx
Cc: Miller, Jay; oracle-l@xxxxxxxxxxxxx
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@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 <http://9.2.0.7/>
Thanks,
Jay Miller
Other related posts:
