Menu

Current User

0 votes

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

in How To by (150 points)
recategorized by

1 Answer

0 votes
 
Best answer

Hello Glen, what you are looking for are audit values.

dbFront provides those for exactly that purpose. Please see: https://dbfront.com/auditvalues

by (64.3k points)
selected by
That's perfect!  Thanks!
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...