Re: Auditing Stored Procedures

From: Vince <vinnyop_at_yahoo.com>
Date: 2 Nov 2006 14:23:52 -0800
Message-ID: <1162506232.374661.217950@h48g2000cwc.googlegroups.com>

DA Morgan wrote:
> raju wrote:
> > 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

>

> Please stop top posting. Scroll to the bottom to reply.

>

> Answer ... you go through each and every one of those 1600 procedures
> and implement a single line call to a utility proc that inserts a row
> into a table.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

And maybe even create a new standalone or packaged procedure to do this, using the autonomous transaction feature, so when a rollback situation occurs, the use of the procedure would still get recorded. Received on Thu Nov 02 2006 - 16:23:52 CST