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 |
|
vyelchri
Starting Member
12 Posts |
 Posted - 2009-06-24 : 01:04:51
|
| Hi,i want to remove alter permission on the trigger and i want to give just select permission to some users. i am using SQL Server 2005 When i right click on trigger, i am not able to see "properties" option for triggers.Is Security not possible on triggers.Thanks,VB |
|
|
Directory
Starting Member
5 Posts |
Posted - 2009-06-24 : 01:59:43
|
| Trigger is running by SQL engine.You cannot be give permission on trigger.If your concern is "to restrict the user modifying on trigger", you can give permission onyour user account. |
 |
|
|
|
|
|
Remove alter permissions on Trigge