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 |
|
csvlmc
Starting Member
2 Posts |
 Posted - 2008-10-20 : 14:05:33
|
| Hi there, I have a situation here. I need to grant/deny database users from enabling/disabling triggers. The scenario is simple, I have a main database and an audit database and changes are stored in the 2nd by audit triggers. Problem is I need to be able to create administrators that CANT disable the audit triggers (you can imagine why).Is there a way to do this?? Users should (in theory) still be able to alter tables, just not to mess with trigger's state.Thanks a lot in advance!!!(I ended up here for what i think is a nice forum and I hope I can be of any use in the future as you are to me now) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-20 : 14:07:56
|
| isnt it enough to deny alter trigger permission for all the administrators? |
 |
|
|
csvlmc
Starting Member
2 Posts |
Posted - 2008-10-20 : 14:11:50
|
| Well, if by doing that I deny them to enable/disable as well, that would do the drill. Does that denies user to disable the trigger?Please tell me more, if you can.And thanks for such a quick answer! (I just refreshed after 30 seconds and.... there you are!) |
|
|
|
|
|
|
deny/grant disable/enable trigger