Re: How to control the security in this case?
From: Uri Dimant (urid_at_iscar.co.il)
Date: 07/19/05
- Previous message: BBFrost: "Re: Visual Studio gives direct dbo access to Sql Server 2000 ??? <<Update>>"
- In reply to: Alejandro Mesa: "RE: How to control the security in this case?"
- Next in thread: Ivan: "Re: How to control the security in this case?"
- Reply: Ivan: "Re: How to control the security in this case?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 19 Jul 2005 10:06:46 +0300
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
> >
> >
- Previous message: BBFrost: "Re: Visual Studio gives direct dbo access to Sql Server 2000 ??? <<Update>>"
- In reply to: Alejandro Mesa: "RE: How to control the security in this case?"
- Next in thread: Ivan: "Re: How to control the security in this case?"
- Reply: Ivan: "Re: How to control the security in this case?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|