| how to moineteing the updating of data [message #297749] |
Sun, 03 February 2008 05:21  |
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
|
Member |
|
|
Dear All
I want to moniter the entering data of a user
I mean if the user enters data and before he commit he made change of the data
i want to know the data he entered and updated before he commits
best regards
|
|
|
|
| Re: how to moineteing the updating of data [message #297751 is a reply to message #297749] |
Sun, 03 February 2008 05:42  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Create BEFORE INSERT / BEFORE UPDATE database triggers which will insert "old" records into the "archive" table. This "archive" table might look exactly the same as the original one, but you might add "timestamp" and "who did that" columns so that you'll gather some extra information.
Or, if you don't like this approach, enable database auditing.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
