Post reply

DTS Execute Permissions

  • November 8, 2004 at 2:23 pm

    #66638

    What rights are required for a user to execute a DTS package?

  • November 8, 2004 at 3:06 pm

    #529373

    minimum:  they will need at least db_reader and db_writer and own the dts package.  they will not be able to execute the package as a job.  That is a sysadmin role function

  • November 8, 2004 at 3:10 pm

    #529375

    Thanks for your help.

  • November 9, 2004 at 8:00 am

    #529457

    I have a 2000 DTS package that has a T-SQL step that accepts global variables as parameters.  One of my users needs to be able to execute this package.  I've had him recreate the package so he is the owner and I granted him dbo permissions.  When he tries to run the package it says that the parameters are not set.  He sets them and resaves the package but gets the same error.  He can run other packages just fine, just not ones with parameters.  I granted him SA and he can now run this package.  Does anyone know why this is?  Do you really have to be sa to run a package with parameters?

    Thanks,

    Jason

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

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