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 still
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
Hi
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 still
> 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 still
>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
sqlsql

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

DTS Package- Check its useability

I have a quick question, I am working on some new SQL Servers that
were being managed by other DBA's. I am going through a list of DTS
packages and there are some that I am not certain if they are being
used anymore. Is there a way in SQL Server to identify how often the
DTS packages are being executed so that I can tell if it is being
used?
Any help in this regard will be greatly appreciated.
Thanks
If logging is already enabled, right click the package and select Package
Logs.
If logging is not enabled you can enable it. Open the package, go to Package
in the menu, Properties, Logging tab and Logging section.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"shub" wrote:

> I have a quick question, I am working on some new SQL Servers that
> were being managed by other DBA's. I am going through a list of DTS
> packages and there are some that I am not certain if they are being
> used anymore. Is there a way in SQL Server to identify how often the
> DTS packages are being executed so that I can tell if it is being
> used?
> Any help in this regard will be greatly appreciated.
> Thanks
>

DTS Package- Check its useability

I have a quick question, I am working on some new SQL Servers that
were being managed by other DBA's. I am going through a list of DTS
packages and there are some that I am not certain if they are being
used anymore. Is there a way in SQL Server to identify how often the
DTS packages are being executed so that I can tell if it is being
used?
Any help in this regard will be greatly appreciated.
ThanksIf logging is already enabled, right click the package and select Package
Logs.
If logging is not enabled you can enable it. Open the package, go to Package
in the menu, Properties, Logging tab and Logging section.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"shub" wrote:

> I have a quick question, I am working on some new SQL Servers that
> were being managed by other DBA's. I am going through a list of DTS
> packages and there are some that I am not certain if they are being
> used anymore. Is there a way in SQL Server to identify how often the
> DTS packages are being executed so that I can tell if it is being
> used?
> Any help in this regard will be greatly appreciated.
> Thanks
>