Post reply

Permission question

  • October 30, 2012 at 4:25 am

    #284212

    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

    #1554251

    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

    #1554991

    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