Giving permission for a user to run a pkg

  • I have a staff member who needs to run one DTS package. The only problem is the person cannot see the list of DTS packages via EM when she logs in, and cannot see the packages using DTSRunUI either, unless I grant Site Administrator access. I definitely don't want to give her access as SA if she just reads and edits data and executes one package. How can I allow a non sys-admin user to see and execute the package??

  • This was removed by the editor as SPAM

  • Hi, create a userDTS in you msdb database and give permissions to this user to run the package.

    Regards

    JFB

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply