RE: Disconnecting session from an on logon trigger

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_at_gmail.com] Sent: Friday, October 12, 2007 6:16 PM
To: roman.podshivalov_at_gmail.com
Cc: Miller, Jay; 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