Users permission to run DTS without being sysadmin

From: "Berimu" <Ivo.mulders@xxxxxx>
Date: 17 Jan 2007 04:31:37 -0800

We would like users to run DTS packages in a production without them
being sysadmin or owner of the package? Is this possible using
securitysettings and not a VB, .net interface?

Ivo

.

Follow-Ups:
- Re: Users permission to run DTS without being sysadmin
  - From: Allan Mitchell

Prev by Date: Re: Global Variables in Logging tab
Next by Date: RE: SQL 2005: Microsoft OLE DB Providers for DB2 not working with
Previous by thread: DTS package remotely
Next by thread: Re: Users permission to run DTS without being sysadmin
Index(es):
- Date
- Thread

Relevant Pages

Problems changing dts packages.
... we have a user that create some dts packages. ... He is the owner of the ... Onlye members of the sysadmin server role can change the dts or the ... How can i resolve this problem without adding to the sysadmin server ...
(microsoft.public.sqlserver.dts)
DTS Owner
... create DTS packages it shows my userid as the owner, I want dbo to be the ... owner of the package. ... to make dbo the owner, but don't know how to for DTS, I ...
(microsoft.public.sqlserver.dts)
Cannot edit or delete my DTS packages
... I created 2 DTS packages on SQL Server 2000 that I need to either edit or ... just delete outright. ... saying that "only the owner" of the DTS package can edit or delete it. ... as the OWNER I'm just a little miffed my own packages don't recognize ...
(microsoft.public.sqlserver.dts)