I would like to hear if it is a common table design practice to track the names of the users who modify data along with the dates of the modifications. Several years ago I worked at a company that, for most tables, tracked the following information.
Create User - User Id of person who created the record
Create Date - Date and time of record creation
Modify User - User Id of person who modified the record
Modify Date - Date and time of record modification
Yes, that would be a common practice. There are other methods of tracking changes: specific software that tracks the changes or audit tables that record the changes, but your method is very common.
It can be important for several reasons, two of which are security (knowing who changed data and when), and timeliness of data (when was the last time the data was updated, and does it need to be revisited). There are other reasons too.