I have DTS package 'DTS_TEST' that is own by SQL Server Service account. I created another user giving 'DBO' permission for the Database 'XYZ' on which this DTS package is going to run. when this user try to run this DTS pkg he is not able to run. i don't want to change the owner but need to Grant him access to run this DTS package. ho wi can do that. any help is appreciated. thanking in advance
Try giving the user EXECUTE permission for sp_enum_dtspackages, sp_get_dtspackage, and sp_get_dtsversion in msdb in addition to having permissions in XYZ. I've done this to allow a user to execute a DTS package that it doesn't own.
Greg
Greg
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply