RE: How to control the security in this case?
From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 07/18/05
- Next message: Scott Townsend: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
- Previous message: Pushkar: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- In reply to: Ivan: "How to control the security in this case?"
- Next in thread: Uri Dimant: "Re: How to control the security in this case?"
- Reply: Uri Dimant: "Re: How to control the security in this case?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 18 Jul 2005 07:06:10 -0700
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
>
>
- Next message: Scott Townsend: "Re: Web Applicaiton using Trusted Connections to SQL on different machine?"
- Previous message: Pushkar: "Re: Need to connect to SQL Server on other side of firewall, listening to a different port."
- In reply to: Ivan: "How to control the security in this case?"
- Next in thread: Uri Dimant: "Re: How to control the security in this case?"
- Reply: Uri Dimant: "Re: How to control the security in this case?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
