Re: Auditing Stored Procedures

From: raju <raju1105_at_gmail.com>
Date: 31 Oct 2006 21:06:56 -0800
Message-ID: <1162357616.568850.18670@k70g2000cwa.googlegroups.com>

we have around 1600 stored procedures in 72 packages.

we can issue audit statements directly on objects like tables, procedures, packages, indexes, views,..etc. but how do you audit the stored procedures and find their usage??

-raju

gazzag wrote:
> raju wrote:
> > thanks for your response.
> >
> > But how do you audit stored procedures embedded in a package??....as we
> > cant direclty reference them like tables (audit table).
>
> I'm not in a position to test at the moment, however the documentation
> suggests auditing "EXECUTE PROCEDURE" is possible:
>
> http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_48a.htm#2059578
>
> HTH
>
> -g
Received on Tue Oct 31 2006 - 23:06:56 CST