As many people do, we have tables that contain the following fields:
We can hide CreatedBy and CreatedOn and set them with default constraints at the database level. However, ModifiedBy and ModifiedOn is more difficult without using (resource-expensive) triggers. It would be better if there was a way to set these in dbfront.
You can have dbFront automatically populate the ModifiedBy and ModifiedOn fields by means of the Audit Value property on fields.
Please see the following links for further instructions.