DTS PACKAGES SECURITY ISSUE

Hi,
I need to give access to a user to use enterprise manager to create DTS
packages within a single database. However I have a problem that he can stil
l
see other DTS packages and open them. IS there any way of restricting the DT
S
packages so that he can only see what he had created and not others?
Thanks
AnpHi
It is not a good idea to develop DTS packages against a live system. You may
want to create a safe environment on a different server for this person to
work with.
John
"Anup" wrote:

> Hi,
> I need to give access to a user to use enterprise manager to create DTS
> packages within a single database. However I have a problem that he can st
ill
> see other DTS packages and open them. IS there any way of restricting the
DTS
> packages so that he can only see what he had created and not others?
> Thanks
> Anp|||Additionally, you can secure DTS packages with DTS package
passwords. You can find explanations of this in books online
under the topic: Handling Package Security in DTS
-Sue
On Wed, 17 Aug 2005 23:11:01 -0700, "Anup"
<Anup@.discussions.microsoft.com> wrote:

>Hi,
>I need to give access to a user to use enterprise manager to create DTS
>packages within a single database. However I have a problem that he can sti
ll
>see other DTS packages and open them. IS there any way of restricting the D
TS
>packages so that he can only see what he had created and not others?
>Thanks
>Anp