July 12, 2007 at 7:16 am
I've been trying to come up with all the permissions necessary to give a NON-System Administrator the necessary permissions to edit, execute and change DTS packages. Can someone help me?
July 12, 2007 at 10:35 am
I've found that the Public role in msdb has the needed permissions by default, but if someone has changed that in your instance, you can grant EXECUTE to the following stored procedures to the non-sysadmin user:
sp_enum_dtspackagelog
sp_enum_dtspackages
sp_enum_dtssteplog
sp_enum_dtstasklog
sp_get_dtspackage
sp_get_dtsversion
sp_drop_dtspackage
sp_add_dtspackage
The user will be able to execute packages that it creates.
Greg
Greg
July 12, 2007 at 11:50 pm
You would be needed to give some permissions to some tables nad stored procedures in msdb database.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply