Re: DTS Package security

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/08/05 

Date: Mon, 07 Nov 2005 22:53:01 -0700

Don't think so. The options on package security are user
password can just run, owner password can edit and run the
package.
You can find more information in books online under the
topic: Handling Package Security in DTS

-Sue

On Mon, 7 Nov 2005 10:33:05 -0800, Matthew Z
<MatthewZ@discussions.microsoft.com> wrote:

>Hi all,
> is there a way to allow users to be able to look at the DTS packages but no
>chages made to the packages?
>
>Thanks a lot.

Relevant Pages

  • Re: DTS Process Cube Task
    ... Your private dimension sounds like it's exceeding the transaction ... See if you can consistently process just that cube *by ... So you may end up with separate DTS packages to get everything ... >> place it in a different package and invoke it via a Process Task ...
    (microsoft.public.sqlserver.olap)
  • Re: LoadFromSqlServer and owner password
    ... >I have a SQL Package with a owner password and a execute password(is ... This means that a user can execute a package but not ... Darren Green (SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Passing Global Variables, type (date) via DTSRun
    ... The package called inside this step and the package called from the similar ... >> several DTS packages that have been created by several developers. ... >> a) Use implicit conversion by setting a nvarcharvariable to the ...
    (microsoft.public.sqlserver.dts)
  • RE: VBScripts or JScripts
    ... Global variables that do not exist when first ... Prior to package execution, you can create global ... how to use ActiveX scripts in DTS ... Using Global Variables with DTS Packages ...
    (microsoft.public.sqlserver.dts)
  • RE: VBScripts or JScripts
    ... Global variables that do not exist when first ... Prior to package execution, you can create global ... how to use ActiveX scripts in DTS ... Using Global Variables with DTS Packages ...
    (microsoft.public.sqlserver.dts)