|
Home > Archive > MS SQL Server security > July 2005 > How to control the security in this case?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to control the security in this case?
|
|
|
| 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
| |
| Alejandro Mesa 2005-07-18, 9:23 am |
| 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
>
>
| |
| Uri Dimant 2005-07-19, 3:23 am |
| Hi, Alejandro
I'm afrais that does not solve the problem. I still keep seeing the DTS's
created by others.
"Alejandro Mesa" < AlejandroMesa@discus
sions.microsoft.com> wrote in message
news:B1A8ECBE-047C-4095-889A- A7DA9C4BFD04@microso
ft.com...[color=darkred]
> Open the packages in design mode, use "save as" and set the owner and user
> password.
>
>
> AMB
>
> "Ivan" wrote:
>
database.[color=darkred]
office[color=darkred
]
have a[color=darkred]
even[color=darkred]
lot.[color=darkred]
| |
|
| 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@discus
sions.microsoft.com> wrote in message
> news:B1A8ECBE-047C-4095-889A- A7DA9C4BFD04@microso
ft.com...
> database.
> office
> have a
> even
> lot.
>
>
>
|
|
|
|
|