Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-02-04 : 22:33:48
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-04 : 22:55:29
|
| 3 triggers on single table? can you tell whats the purpose of them?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-02-05 : 08:14:20
|
| 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-05 : 10:08:16
|
| why do you need separate triggers? cant you create a single DML trigger for handling all the operations?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-02-05 : 20:53:45
|
| Thanks! |
|
|
|
|
|
|
permissions on sql server triggers