RE: Audit - Stored procedure creation
- From: amihay gonen <agonenil@xxxxxxxxx>
- To: mark.powell2@xxxxxx
- Date: Thu, 3 Apr 2014 08:14:07 +0300
Another option is to use ddl trigger
psoug.org/reference/ddl_trigger.html
On 2 Apr 2014 22:51, "Powell, Mark" <mark.powell2@xxxxxx> wrote:
> 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> 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> 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
>
>
>
Other related posts: