Save Operations log to database with system user field

Asked

Viewed 331 times

3

Hello,

would like to know how to by means of triggers in the bank I get beyond saving the operations performed and in which table held also the user logged into the system (not the bank user, if the system user) at the time of the change.

In which case I would have: [User Table] [Product Table] [Log Table]

All changes made to the user or product table should generate a row in the log table, with:

date, operation (I,U,D), table, user(user table), modified record id.

I appreciate the returns.

c# database sqlite winforms

1 answer

0

For triggers I know you’d have to create one for each table. depending on the system you better do some method that every database execution send the record to the LOG table

  • Yeah, I know I’d have to create a Rigger for every table. The problem I’m trying to solve is getting the user of the system who made the table change by a Rigger. I don’t know if I’m being clear, but that’s my problem. Thank you for the answer.

Browser other questions tagged c# database sqlite winforms

You are not signed in. Login or sign up in order to post.