What would be a good method to handle an audit trail?

I'm looking to implement an audit trail as a mechanism to track changes to the data and see what has changed, by who and when. I can setup a trigger based audit system which I have used in the past but that doesn't track the user making the changes. It stores the user that is changing the record, which in radzen is a service account that connects to the database. Just curious what, if any, other solutions people have done for this.


You can check this thread.