Re: Permission for running DTS

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 07:11:56 -0000

Add them to msdb.

You could also go through the DTS stored procs and grant access to them
only. 

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Obaid" <anonymous@discussions.microsoft.com> wrote in message
news:12d9c01c411ee$f12244a0$a301280a@phx.gbl...
> We have removed guest from the msdb database. Can they
> still run the DTS package in any other way without adding
> guest to the msdb database.
>
> >-----Original Message-----
> >Yep.
> >
> >All you need is a login to the server (provided you have
> not removed guest
> >from msdb)
> >
> >That only gives you access to the packages.  You then
> need to consider what
> >those packages do.
> >
> >
> >
> >-- 
> >-- 
> >
> >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> >www.SQLDTS.com - The site for all your DTS needs.
> >I support PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >
> >"Obaid" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:e59401c411e9$078bef80$a001280a@phx.gbl...
> >> Can a login with no dbo/admin perms be given perms to
> >> execute dts packages on the production server.
> >
> >
> >.
> >

Relevant Pages

  • Re: SQLEM: Package Error: "The system cannot find the file specified." on open of DTS Pack
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... > In trying to open a DTS package from SQL Enterprise Manager, ... > the error message: "Error Source: Microsoft Data Transformation ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing a DTS package from ASP.NET
    ... Hey, I have company. ... See the thread 'DTS from ... > file in my own machine, only SQL Server in another machine. ... > approach to run this DTS package triggered by web? ...
    (microsoft.public.sqlserver.dts)
  • Re: Where in msdb can I find Active X Scripts from a DTS package
    ... DTS Package data is stored in a system table in msdb, called sysdtspackages, ... How to Upgrade to SQL Server 2000 Retail Version After SQL Server 2000 ... I am trying to recover a DTS package containing an ACtive X Script after my ...
    (microsoft.public.sqlserver.programming)
  • Re: Importing CSV Files Into MSDE Databases
    ... Create a DTS package and save it as a Visual Basic module. ... Drag a Text File as data source and drag a Microsoft OleDb ... Provider for SQL Server as destination. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DTS MS MSQL SERVER
    ... If you store them on the file system then they could be anywhere ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... if posible to copy msdb files and paste on another PCwithout lost DB's> ...
    (microsoft.public.sqlserver.dts)
Loading