October 30, 2012 at 4:25 am
Suppose there is a tableA and trigger defined for Insert, Update and delete to populate audit table say tableB. Now If i want to give a user U1 write permissions on table tableA, will the trigger work on any kind of operation to populate audit table ? The case here is that user has access only to main table and not audit table.
October 30, 2012 at 10:05 am
sqlnaive (10/30/2012)
Suppose there is a tableA and trigger defined for Insert, Update and delete to populate audit table say tableB. Now If i want to give a user U1 write permissions on table tableA, will the trigger work on any kind of operation to populate audit table ? The case here is that user has access only to main table and not audit table.
If tableA and tableB have the same owner (or are in the same schema, e.g. dbo) then you do not need to grant any explicit permissions to U1 on tableB.
Read more about ownership chaining here.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
November 1, 2012 at 7:18 am
Thanks a lot opc.three. This helped.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply