Possible to add UPDATEDBY or MODIFIEDBY column to [dbo].[ChargesTable]?
Hi All -
I have a unique need to restrict the ChargesTable from unauthorized worklog entries for prior weeks.
I was able to handle most of my need using JSON validation rules. However, each Monday/Tuesday, I revert the rules to "open" it up for manager inputs/edits, however there are some technicians who know of this window and "sneak in" changes.
Therefore I want to enable a database trigger to prevent those situations. Essentially, I have an exception list that contain folks that ARE able to make those changes and I want it to fail for everyone else.
The challenge is there is only the CREATEDBY and TECHNICIANID columns present. So when enabling the database trigger, it doesn't work as expected because the CREATEDBY id can be an ID NOT IN the exception list. And since sometimes the Manager is only making an edit, NOT adding a brand new worklog.
Is that possible?
I was able to handle most of my need using JSON validation rules. However, each Monday/Tuesday, I revert the rules to "open" it up for manager inputs/edits, however there are some technicians who know of this window and "sneak in" changes.
Therefore I want to enable a database trigger to prevent those situations. Essentially, I have an exception list that contain folks that ARE able to make those changes and I want it to fail for everyone else.
The challenge is there is only the CREATEDBY and TECHNICIANID columns present. So when enabling the database trigger, it doesn't work as expected because the CREATEDBY id can be an ID NOT IN the exception list. And since sometimes the Manager is only making an edit, NOT adding a brand new worklog.
Is that possible?