Re: Auditing Stored Procedures

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