 | |
Restrict DTS execution
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Restrict DTS execution -
03-05-2006
, 04:40 PM
#2
| |||
| |||
|
|
Does anyone know how to restrict the execution of DTS packages? The case is I've got some developers who want to see the packages that are currently created but I do not want them to run those packages. I already know how to restrict the creation via sp_add_dtspackage. |
#3
| |||
| |||
|
|
Hello FJC, See them in what way? Just see them in EM? If you want to stop them from executing them then assign a user password to the packages. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Does anyone know how to restrict the execution of DTS packages? The case is I've got some developers who want to see the packages that are currently created but I do not want them to run those packages. I already know how to restrict the creation via sp_add_dtspackage. |
#4
| |||
| |||
|
|
Hi Allan, Yes in EM, is there any other way other than to assign a password? Thanks "Allan Mitchell" wrote: Hello FJC, See them in what way? Just see them in EM? If you want to stop them from executing them then assign a user password to the packages. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Does anyone know how to restrict the execution of DTS packages? The case is I've got some developers who want to see the packages that are currently created but I do not want them to run those packages. I already know how to restrict the creation via sp_add_dtspackage. |
#5
| |||
| |||
|
|
Hello FJC, Can you not just restrict access to sp_get_dtspackage? Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hi Allan, Yes in EM, is there any other way other than to assign a password? Thanks "Allan Mitchell" wrote: Hello FJC, See them in what way? Just see them in EM? If you want to stop them from executing them then assign a user password to the packages. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Does anyone know how to restrict the execution of DTS packages? The case is I've got some developers who want to see the packages that are currently created but I do not want them to run those packages. I already know how to restrict the creation via sp_add_dtspackage. |
#6
| |||
| |||
|
|
Hi Allan, I can, but I already know what they're going to say when they realise they cannot see the packages, but if it is the solution so be it, in the end if they want to see if a package was executed or not I can give them a daily report. Thanks for your help Allan. "Allan Mitchell" wrote: Hello FJC, Can you not just restrict access to sp_get_dtspackage? Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hi Allan, Yes in EM, is there any other way other than to assign a password? Thanks "Allan Mitchell" wrote: Hello FJC, See them in what way? Just see them in EM? If you want to stop them from executing them then assign a user password to the packages. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Does anyone know how to restrict the execution of DTS packages? The case is I've got some developers who want to see the packages that are currently created but I do not want them to run those packages. I already know how to restrict the creation via sp_add_dtspackage. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.