SQL Server：根据应用程序用户记录数据库更改

I want to accomplish that when say user "123" logs into the application and then does changes to data in the database, that this change will be logged into a mirror table with "123" in an extra column.I want to accomplish that when say user "123" l