2. Now, someone is having trouble updating data. The issue seems to be that a trigger fires during the update. In the trigger the code tries to delete from a table in the previously delete-denied databases. So the update fails.
I have a little confusion about the trigger that you are talking about in the above mentioned point. Is this a constraint in your application.
I did a test setup, Made a new database a new login and denied delete on this login.
I was able to update the data without any issues.
Regards
Shafat Husain
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)