Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Thu, 25 May 2006 06:52:50 -0500 Reply-To: "Mark C. Stock" From: "Mark C. Stock" Newsgroups: comp.databases.oracle.server References: <1148556564.001331.275890@j55g2000cwa.googlegroups.com> Subject: Re: Auditing when a function was executed Date: Thu, 25 May 2006 07:52:50 -0400 Organization: Enquery, Incorporated X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Message-ID: <2e2dnUMoxdEPB-jZnZ2dnUVZ_tmdnZ2d@comcast.com> Lines: 24 NNTP-Posting-Host: 68.57.99.188 X-Trace: sv3-AIUG+03nzsxIuhhdjUHfQDXPt9YRwQW6k5d63BlnBR618W+t1ecTe6R8UyNQC2iV3wJwLDawYgYH1aC!0iItEYSX0e2G/kx3gQSZSvQ8wKYYMcoRAt/QdBVHnK1zPB8EaHB+8u8UBuwBBr6NNph8Qd6mcZ5f!VeoCy3RFJ9e3UaM= X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268012 wrote in message news:1148556564.001331.275890@j55g2000cwa.googlegroups.com... :I am on HP UNIX 11i using Oracle 9.2.0.5. : I want to audit when a PL/SQL function is executed. I do not have : access : to this Oracle function (It is third party and wrapped, and I cannot : modify it). Is there anyway e.g., through t DDL triggers to record when : and who is executing the function. Any ideas are welcome. : did a quick search on tahiti and a quick google for 'audit execute' does this do it for you? http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_48a.htm#2119552 also see if this helps: http://www.oracle-base.com/articles/8i/Auditing.php ++ mcs