RE: DTS permissions to create

From: Davy (Davy_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 09:09:02 -0700

You could try revoking or denying write permissions to msdb. this is where dts package information is stored I believe.
In theory the creation of a package should fail if it cannot be written to msdb.

"Angelina" wrote:

> How to I revoke the ability of non-sa non-dbo users from
> creating DTS packages on a SQL 2000 server?
>
> Thx!
>

Relevant Pages

  • 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)
  • Restore a DTS Packaga Saved As Visual Basic File?
    ... SQL Server 2000 DTS package deleted from MSDB. ... DTS package previously saved as a Visual Basic file. ... Is there a way to restore the DTS package to the SQL Server MSDB using only the Visual Basic file? ...
    (microsoft.public.sqlserver.dts)
  • Re: recovery of dts packages
    ... Was your colleague saving the dts package to SQL Server? ... data can be found in the sysdtspackages table of msdb database. ...
    (microsoft.public.sqlserver.dts)
  • Deleting logs
    ... I have designed a DTS package and have enabled SQL Server logging in ... the properties of the DTS package. ... Since this is writing to the msdb, ...
    (microsoft.public.sqlserver.dts)
  • Re: Restore a DTS Packaga Saved As Visual Basic File?
    ... Open the VB module file in VB and add a reference to the DTS Package Object ... No MSDB backkup. ... Is there a way to restore the DTS package to the SQL Server MSDB using only the Visual Basic file? ...
    (microsoft.public.sqlserver.dts)