topic Re: Logging database access per user in Application Development and Automation Discussions

Logging database access per user

dhorions — Tue, 31 Oct 2006 14:51:47 GMT

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 previous values of updated record

- all new values of updated record

delete : - all previous values of deleted record

I do not mean a system wide table history (scu3).

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

Re: Logging database access per user

Former Member — Tue, 31 Oct 2006 17:44:06 GMT

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

Re: Logging database access per user

dhorions — Tue, 31 Oct 2006 18:38:19 GMT

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?

Re: Logging database access per user

Former Member — Tue, 31 Oct 2006 19:28:18 GMT

Dries,

You are correct.