SQL Server Performance

DTS Security

Discussion in 'SQL Server DTS-Related Questions' started by gfbaker, Aug 14, 2003.

  1. gfbaker New Member

    We 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!!
  2. vbkenya New Member

    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.


    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
  3. catabaye New Member

    Can the people who know the user password view the DTS package?
  4. satya Moderator

    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.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page