Data Base Logging

Question

What is bast way to logging changes in DB?

Answer 1

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.