SQL Server Performance Forum – Threads Archive
DTS SecurityWe have a number of developers creating new DTS packages. The packages are owner by the user that created them. Is there any way for other users to edit these packages short of being given ‘SA’ authority. Thanks for your help!!
When saving DTS packages to SQL Server, you will get an option to specify a user password and an owner password. -Setting a user password ensures that only those people who know the password can execute the package.
-Once the owner password is set, one cannot modify the package without knowing this password. I don’t think you have to make the whole dev team ‘sa’s . Just share the owner password.
Can the people who know the user password view the DTS package?
No, only when they know owner password. If the job is owned by a login that is not a member of the sysadmin fixed server role, the package runs under the context of the job step proxy account, with the rights and permissions of that account. For more information refer to books online for DTS — Security topic. _________