-
permissions for trigger to update another db table
I have a trigger on an orders table. It checks against a patientmaster table to see if the sentflag is set to n or y. If it is "n" I need to push a record to a table on a separate db table. The user has permissions on the orders table. Without having the user be added and given permissions on the second db and table, what would be the best approach inside the trigger to handle this. I am using nt/sql security for this
-
-
How does creating by sa make a difference. When it fires doesn't it check the sql permissions for the user?
-
If you don't add user to second db, then should enable cross db ownership chaining and ensure all related db objects have same owner.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|