Re: How to control the security in this case?

From: Ivan (Ivan_at_discussions.microsoft.com)
Date: 07/19/05 

Date: Tue, 19 Jul 2005 00:38:09 -0700

Hi Uri,

It is allowed that the colleague in the regional office to create his own
DTS. I just don't want to view the DTS created in my head office.
Besides setting password in each DTS package, is there any other way?
Thanks.

Ivan

"Uri Dimant" wrote:

> Hi, Alejandro
> I'm afrais that does not solve the problem. I still keep seeing the DTS's
> created by others.
>
>
> "Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in message
> news:B1A8ECBE-047C-4095-889A-A7DA9C4BFD04@microsoft.com...
> > Open the packages in design mode, use "save as" and set the owner and user
> > password.
> >
> >
> > AMB
> >
> > "Ivan" wrote:
> >
> > > Dear all,
> > >
> > > I have a SQL Server 2000 in my head office, it has several databases.
> > > However, one of the databases is maintained by a colleague of a regional
> > > office. He has the all the authority (read / write) to work on this
> database.
> > > But there is a problem, we have developed some DTS packages in head
> office
> > > and this colleague is going to make his own packages. We would like to
> have a
> > > control that this colleague is not able to access our DTS packages (not
> even
> > > read), he can only opens his own the DTS packages.
> > > Is there any control to achieve this purpose? Please advise. Thanks a
> lot.
> > >
> > > Ivan
> > >
> > >
>
>
>