Permissions to run DTS packages

• matey

  SSCommitted

  Points: 1845

  More actions

  September 13, 2006 at 8:03 am

  #61336

  I'm a bit sceptical about the permission I can assign to users to give them the rights to execute DTS packages. Can anyone tell me what permissions I can give to the users without making them SA.

• mrivera

  Ten Centuries

  Points: 1050

  More actions

  September 13, 2006 at 9:02 am

  #660121

  This article can help you: http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp

  --M

• matey

  SSCommitted

  Points: 1845

  More actions

  September 13, 2006 at 9:18 am

  #660123

  thanks for the response but it does not help much...

• Sreejith Sreedharan

  SSCertifiable

  Points: 5403

  More actions

  September 13, 2006 at 9:24 am

  #660126

  From your question I feel that that article tells you want you need to do? Am I missing something?

   

• mrivera

  Ten Centuries

  Points: 1050

  More actions

  September 13, 2006 at 10:54 am

  #660162

  By default, the permissions are assigned to allow everybody with a valid login.

  What else do you need?