I knew I'd miss one detail - 9.2.0.5 on AIX. I've tested from client versions 9.2.0.5 and 8.1.6.
Jay
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Powell, Mark D Sent: Wednesday, March 02, 2005 9:52 AM To: oracle-l@(protected) Subject: RE: Logon trigger isn't restricting logon
What version of Oracle are you on? When Oracle first introduced Database Event Triggers the raise application error routine could not be used to kill the logon. Instead you had to save the sid and serial# for the session in a table and launch another session (dbms_job or daemon process) that read the table and performed the kill operation. This restriction was lifted later (probably with ver 9).=20
HTH -- Mark D Powell --
**DISCLAIMER This e-mail message and any files transmitted with it are intended for the = use of the individual or entity to which they are addressed and may contain= information that is privileged, proprietary and confidential. If you are n= ot the intended recipient, you may not use, copy or disclose to anyone the = message or any information contained in the message. If you have received t= his communication in error, please notify the sender and delete this e-mail= message. The contents do not represent the opinion of D&E except to the ex= tent that it relates to their official business. -- http://www.freelists.org/webpage/oracle-l
