RE: Audit - Stored procedure creation
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Apr 2014 19:49:11 +0000
Nik, if auditing in enabled then the "audit procedure" statement will audit all
CREATE, and DROP procedure statements ran on the database. So depending on how
long you keep such audit information would determine if you had a record of the
procedure being created or dropped.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Nik Tek
Sent: Wednesday, April 02, 2014 12:45 AM
To: Adam Musch
Cc: ORACLE-L
Subject: Re: Audit - Stored procedure creation
Thank you Adam!
Can you please provide an example or pointers?
Thank you
Nik
On Tue, Apr 1, 2014 at 9:42 PM, Adam Musch
<ahmusch@xxxxxxxxx<mailto:ahmusch@xxxxxxxxx>> wrote:
Yes - if you had run AUDIT PROCEDURE before creation. Or if you'd SET ECHO ON
and saved the log file from the deployment from SQL*Plus or equivalent.
On Tue, Apr 1, 2014 at 11:38 PM, Nik Tek
<niktek2005@xxxxxxxxx<mailto:niktek2005@xxxxxxxxx>> wrote:
Hi,
Is there a way to find that a certain stored procedure was ever created in
Oracle?
When I deploy the schema from a file, I'm missing few SPs, I wanted to know if
the stored procedure was ever tried to deploy.
Thank you
Nik
--
Adam Musch
ahmusch@xxxxxxxxx<mailto:ahmusch@xxxxxxxxx>
Other related posts:
