Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Permission question Expand / Collapse
Author
Message
Posted Tuesday, October 30, 2012 4:25 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, October 10, 2014 7:07 AM
Points: 3,545, Visits: 2,654
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.
Post #1378664
Posted Tuesday, October 30, 2012 10:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:09 PM
Points: 7,125, Visits: 12,722
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
Post #1378872
Posted Thursday, November 1, 2012 7:18 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, October 10, 2014 7:07 AM
Points: 3,545, Visits: 2,654
Thanks a lot opc.three. This helped.
Post #1379796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse