Audit columns – Created by and Updated By

I have seen two database designs to store the value in Created by and Updated By columns as: Store the PK of user in Created by and Updated By columns Store the user name in Created by and Updated By columns Now you may have question: What is best practice to store the value in the Created by and Updated By columns and why? My opinion is PK of user (user id) is preferred over user name. There are various

» Read more