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
10.0.1.0.

Any suggestions?

Thanks a bunch!!

On Aug 12, 10:28*am, artme...@yahoo.com 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
> 10.0.1.0.
>
> 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 --