DTS execute permissions

• Moenier Davids

  SSC Eights!

  Points: 885

  More actions

  June 3, 2009 at 9:35 am

  #204974

  Hi

  I would like to know what permissions or roles would need to be granted to a user inorder to execute a dts. I do not wan't to grant the user system admin rights on the sql box; they should just be able to execute a dts from Enterprise manager and not be able to edit or modify any dts

  Thanks

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  June 3, 2009 at 12:58 pm

  #1004239

  See my reply here: http://www.sqlservercentral.com/Forums/Topic728068-146-1.aspx

  Greg