Post reply

DTS Administration Permissions - NON SysAdmins

  • July 12, 2007 at 7:16 am

    #179691

    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

    #719033

    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

    #719178

    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