RE: Logon trigger isn't restricting logon
- From: "Hostetter, Jay M" <JHostetter@xxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Mar 2005 10:21:32 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark D
Sent: Wednesday, March 02, 2005 9:52 AM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
