Re: Auditing

From: Mark D Powell <>
Date: Tue, 12 Aug 2008 10:49:22 -0700 (PDT)
Message-ID: <>

On Aug 12, 10:28 am, wrote:
> I cannot seem to find any good documentation on this:
> We have a user logging in and executing a procedure which creats some
> data to be inserted into some table.  Some key information is missing
> though.
> We do not know what the 'trail' is of that user and how he gets to the
> 'create data' section.  We want to audit that user and see if we can
> track what procedures he is executing to get to the point of missing
> data.
> Can this be done?  I've been looking at FGA.  We are running 10g r2
> Any suggestions?
> Thanks a bunch!!

Have you looked at the standard features provided by the built-in audit command which is documented in the Security Guide?

Also you might just consider setting sql trace (with binds) on for the user and seeing what the trace file shows.

Hope these give you some more to think about while you are determining your best approach.

  • Mark D Powell --
Received on Tue Aug 12 2008 - 12:49:22 CDT

Original text of this message