November 22, 2006 at 5:51 am
Hi Guys
What level of rights do I need to give a user that wants to create, schedule and run DTS packages? Thanks for your prompt replies.
November 22, 2006 at 8:42 am
Information on DTS are saved several tables in msdb, such as sysdtsXXX. You may assign users to access to these tables.
November 22, 2006 at 9:31 am
I believe it's better to grant EXECUTE permission to stored procedures in msdb than to grant permissions to the system tables. Basically, the user needs to be able to execute sp_enum_dtspackages to see a list of packages, sp_get_dtspackage to edit a package, and sp_add_dtspackage to create a package.
It may be more difficult to allow a user to schedule a package as a job. He/she needs permission to execute sp_add_job, and xp_cmdshell. I prefer to not allow users/developers to schedule packages.
The policy in our shop is to not allow anyone but DBAs create and schedule packages in production.
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply