Re: Security DTS Packages

From: Klaus (Klaus_at_discussions.microsoft.com)
Date: 03/10/05


Date: Thu, 10 Mar 2005 08:47:05 -0800

well,

thanks.
1) for the answer
2) for the quick resp

;-)

"Simon Worth" wrote:

> Users don't need to be in the admin role to view/edit/create dts packages.
>
> --
> Simon Worth
>
>
> "Klaus" <Klaus@discussions.microsoft.com> wrote in message
> news:08F9BFD8-A5F2-40CC-8E3D-080444F24FE4@microsoft.com...
> > Hi, quick question
> > What is really necessary on security rights to run/change/add DTS
> Packages?
> > I like to remove the User from the SYSAdmin Role but also to make sure the
> > User has enough right to do the work without security problems.
> >
> > Btw:
> > I know that the DTS is stored on the MSDB, is this way to protect the DTS?
> > Thanks for any kind of information.
> >
>
>
>



Relevant Pages

  • Re: Installing DTS packages
    ... But if they are in files, then restoring the msdb database would not restore ... There is one DTS item in the sysdtspackages and that is the one listed ... exec msdb..sp_enum_dtspackages, but that is not one of the packages ...
    (microsoft.public.sqlserver.dts)
  • Re: Installing DTS packages
    ... Allan Mitchell ... But if they are in files, then restoring the msdb database would not ... restore the DTS packages then? ... There is one DTS item in the sysdtspackages and that is the one ...
    (microsoft.public.sqlserver.dts)
  • Re: Wie und wo kann ich ein SSIS Paketen sehen und bearbeiten?
    ... Wenn man DTS Packages seinerzeit deployen wollte, hat man richtig Handstände gemacht, die in die Zielumgebung reinzubekommen. ... Pakete einfach im Filesystem. ...
    (microsoft.public.de.sqlserver)
  • Re: Installing DTS packages
    ... DTS packages may not be aware that they are stored in msdb so he ... so I am looking for the fastest possible ways to recover. ...
    (microsoft.public.sqlserver.dts)
  • DTS Designer Error: The system cannot find the file specified
    ... I can continue to open the DTS package, ... I am running SQL 2000 SP3A Developer Edition on my computer. ... been able to create and edit packages at will. ... that install. ...
    (microsoft.public.sqlserver.dts)

Quantcast