I have sensitive price columns that I would like to have updated only through a stored procedure. I would like all code or manual attempts to alter values in these price columns to fail if it is not using the stored procedures designed to update it.
I am considering implementing this using triggers and a token table. The idea i am considering is to have a token table. the stored procedures will have to first insert values in the token table. Then update the price columns. The update trigger will check if the token exists in the token table for the updated row. if found, it would continue. if the token is not found, it will throw an exception and make the update transaction fail.
Is there a good/better way to implement this restriction?