InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 19:54:39 GMT20http://www.sqlservercentral.com/Forums/Topic1378664-1526-1.aspxThanks a lot opc.three. This helped.Thu, 01 Nov 2012 07:18:54 GMTsqlnaivehttp://www.sqlservercentral.com/Forums/Topic1378664-1526-1.aspx[quote][b]sqlnaive (10/30/2012)[/b][hr]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.[/quote]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 [u][url=http://msdn.microsoft.com/en-us/library/ms188676(v=sql.105).aspx]here[/url][/u].Tue, 30 Oct 2012 10:05:54 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1378664-1526-1.aspxSuppose 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.Tue, 30 Oct 2012 04:25:00 GMTsqlnaive