+ 5

Data Base Logging

What is bast way to logging changes in DB?

4th Oct 2018, 6:31 PM
Igor Shaturnyi (ishPLC)
Igor Shaturnyi (ishPLC) - avatar
1 Odpowiedź
+ 2
First, you can add triggers to any tracked table to listen insert/update/delete. In the triggers just check NEW and OLD values and write them in a special table with columns like table_name, entity_id, modification_time, old_value, new_value, changed_by Second it depends on DBMS, some DBMS will provide tools to capture changes. Tracking login activity is also something that will be specific to the DBMS.
4th Oct 2018, 7:00 PM
asa22