Rights to alter DTS packages

  • Is there some way to grant rights to a user to be able to alter DTS packages that they are not the owner of, without making them sysadmin?

  • Hello

    Have a look at this article, which may provide a possible solution.

    http://www.sqldts.com/default.aspx?212

  • When you save the DTS package you can specify an owner password.  If you do this, even sysadmins won't be able to modify the package without it, but anyone who knows the password will be able to make changes.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

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

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