UID or username

Hi

I am currently designing a new db. Each table will have two fields updated_by and updated_at, which will record who and when the row was last changed. The two fields will be maintained by a trigger. I thought I would store UID in updated_by, but a coworker of mine thinks it is better to store the actual username.

What are the pro's and con's?

Thanks
Peter Laursen Received on Thu Nov 18 1999 - 06:05:03 CST