In a sql server 2008 r2 database I just added 3 triggers to a specific table. Can you tell me if the user and/or application that uses the triggers need to have specific permission levels for the triggers to run. If these permissions are required, can you tell me what permissions are required for the user and/or application to run an access the triggers?
The triggers are setup to keep track on changes from the 'main' table. The 'main' table has triggers for insert, update, and delete. The result of the changes ends up in the 'audit' table.
permissions on sql server triggers
Posted - 02/04/2013 : 22:33:48
