Re: Viewing DTS package properties and Permissions

From: BP Margolin (bpmargo@attglobal.net)
Date: 07/31/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Tue, 30 Jul 2002 19:26:37 -0400

Sue,

While your suggestion is a good first step, it would not defeat a consultant
who knows that DTS packages are stored in the msdb database.

Perhaps addressing the permissions of the msdb database provides additional
protection.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:huvdkuo0hhrte44aaik5hchqaee3gs02v7@4ax.com...
> Another option would be to deny execute permissions on
> sp_enum_dtspackages.
>
> -Sue
>
> On Tue, 30 Jul 2002 12:24:06 -0700, "TO" <cto@aifs.com>
> wrote:
>
> >That would not be practical for development reason as well
> >as for versioning purposes (assuming that I will have to
> >save new and lose all the previous versions). Besides, I
> >have so many packages, to re-save them just won't be easy.
> >
> >
> >>-----Original Message-----
> >>Easiest is probably to use a password when you save it
> >>
> >>HTH
> >>Jasper Smith
> >>
> >>"TO" <cto@aifs.com> wrote in message
> >>news:2e0601c237fa$6562a330$9ae62ecf@tkmsftngxa02...
> >>> I gave user permission "consultant" to my consultant on
> >>> one of the databases. If I need to put security to
> >prevent
> >>> consultant from viewing/modifying my dts packages, how
> >can
> >>> achieve that?
> >>
> >>
> >>.
> >>
>

Relevant Pages

  • RE: Recover SQL files & DST packages from server backup
    ... > after you install the OEM copy on the SBS box. ... If the DTS Packages are saved to SQL Server, they would be saved in the ... > sysdtspackages table in the SQL Server msdb database. ...
    (microsoft.public.windows.server.sbs)
  • RE: Recover DTS
    ... I was able to save all the mdf and ldf ... The DTS packages are stored in the MSDB database. ... restoring the MSDB database. ...
    (microsoft.public.sqlserver.dts)
  • Re: Very Very Urgent, Please Help
    ... does your packages are stored in the MSDB database? ... Have you changed your main package to use the right SQL Server instance? ... When my main dts package calls other dts packages getting timeout immediately. ...
    (microsoft.public.sqlserver.datawarehouse)
  • guest user in msdb
    ... dts packages and i donīt want that this users have ... permissions to create it. ... in the msdb database. ... if i this change can cause problems in sql server. ...
    (microsoft.public.sqlserver.security)