I would like to include a "Stamp User" value in my table, just as I do a "Stamp Date", in order to record the last person to change a record, and when that change was made. Applying the "Stamp Date" is easy enough with a database trigger, but do you have any suggestions for storing the current user on the database record, since from the database's perspective, the current user is the service account assigned to DBFront? Only the application knows the identify of the user currently logged in. Is this stored as a value that could be passed to the database somehow?
Thanks,
Glen