RE: Suppress Logon Trigger for DBMS

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Fri, 7 Oct 2005 16:10:51 -0600
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B873548@fiji.arraybp.com>

The user running a job from dbms_job will have an audsid = 0.

--

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Charlotte Hammond Sent: Thursday, October 06, 2005 10:34 AM To: ORACLE-L
Subject: Suppress Logon Trigger for DBMS_JOB

Hi All,

We have an after logon trigger on our database. This trigger also gets fired by DBMS_JOBs whenever they run which we don't want.

Is there a neat way to prevent this? I was thinking of checking V$SESSION.TYPE within the trigger to detect the BACKGROUND processes but it seems to be null at the time the trigger fires. Another option was to check V$SESSION.PROGRAM but this was getting messy. Any better ideas?

Thanks
Charlotte

PS. Oracle 9.2

Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
--

http://www.freelists.org/webpage/oracle-l

This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 07 2005 - 17:16:41 CDT

RE: Suppress Logon Trigger for DBMS_JOB