Logging database access per user

[dhorions]

I want to know if it is possible to temporarily log database changes on a per user basis.

The data I would need would be :

insert : - all new values of inserted record

update : - all <b>previous values</b> of updated record

- all <b>new values</b> of updated record

delete : - all <b>previous values</b> of deleted record

I do <b>not</b> mean a system wide table history (scu3).

I want to enable the logging for <b>one user</b> for a predetermined <b>period of time</b> over<b> all</b> database tables.

[Former Member]

I believe you can do either system wide logging (assuming your table is flagged for logging) OR enable SQL trace for your user (it needs to be done on all application servers as trace file is created per server).

[dhorions]

I don't want to enable table logging, because it will decrease performance too much for what I need it.

I think SQL trace will not report on the previous values of all fields, so although I also thought about that, I don't think it will do.

Am I right?

[Former Member]

Dries,

You are correct.