Remove alter permissions on Trigger

• vyelchri

  Ten Centuries

  Points: 1304

  More actions

  June 23, 2009 at 11:01 pm

  #155869

  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.

• Balaji-485243

  SSChasing Mays

  Points: 613

  More actions

  June 24, 2009 at 4:08 am

  #1014510

  Hi,

  I want to deny few users from droppring/deleting the triggers in SQL Server 2005.

  Any help is appreciated....

  Thanks,

  Balaji

• ss-457805

  SSCertifiable

  Points: 5872

  More actions

  June 24, 2009 at 4:29 am

  #1014520

  You will need the alter permission on the Table on which your trigger is defined.

  Please refer this:

  http://msdn.microsoft.com/en-us/library/ms176072.aspx

  blog: http://sarveshsingh.comTwitter: @sarveshsing