DTS Security

  • Can anyone help me out here? I am using SQL2000 and I would like to know if I could restrict “users” for looking inside DTS packages. Anyone know if this can be done?

    Thanks Dane-

  • Simplest way is to put a password on the package. There are two levels 'Owner' and 'User'. An Owner password allows the package to be edited and run, the user password only allows the package to be run.

    Thanks

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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