Subject | Last edited by... |
---|---|
Author | pkh2001fi |
Post date | 2002-01-12T18:32:06Z |
Hello,
I need some kind of modification recording for every table. A user
must be able to see who last edited a certain record in a certain
table, and when. I was thinking of placing edited and editedby fields
in every table and then use UPDATE and INSERT triggers to update the
data. The problem is that there will be a huge number of triggers if
I do so. Are there any other options?
Thanks,
-Petter-
I need some kind of modification recording for every table. A user
must be able to see who last edited a certain record in a certain
table, and when. I was thinking of placing edited and editedby fields
in every table and then use UPDATE and INSERT triggers to update the
data. The problem is that there will be a huge number of triggers if
I do so. Are there any other options?
Thanks,
-Petter-