Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Elidas
Starting Member
33 Posts |
 Posted - 2008-03-03 : 12:44:19
|
| Hi, I have created a DTS Package in SQL Server 2000, is there any way that a different user can edit and execute that DTS WITHOUT having server roles?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-03 : 23:06:55
|
| User can execute package but not edit, needs sysadmin rights to edit package owned by other user. |
 |
|
|
Elidas
Starting Member
33 Posts |
Posted - 2008-03-04 : 04:02:21
|
| There isn't other way to grant edit access to the DTS? Maybe a role with some permissions, or making the DTS with a public user? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-04 : 23:15:44
|
| Package owner is windows account, possible if everyone logon windows and connect to sql with common account. |
|
|
|
Elidas
Starting Member
33 Posts |
Posted - 2008-03-05 : 03:52:35
|
| You mean that in order to edit the DTS he has to do that steps everytime?1-log off with his default account2-log on with the new common account3-edit the DTS4-log off with the new common account5-log on with his default account6-keep working until a new DTS needs to be edited |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 23:10:44
|
| Yes if the package is owned by common account. |
|
|
|
Elidas
Starting Member
33 Posts |
Posted - 2008-03-06 : 04:20:52
|
| but... I would have to create a new account for each DTS, because not all DTS must be accesed by everyone. I mean, I may have like 100 DTS and 40 users, some of them must not have access to some of those DTs, some other do.I am not sure if I am explaining myself well |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-06 : 04:41:15
|
| Why are you allowing people to change DTS packages in aproduction environment in the first place? Surely this should be done at the Dev environment level and then the DBA should be making the necessary changes to production (connections etc). |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-06 : 22:54:46
|
| Totally agree. |
|
|
|
|
|
|
How do I grant execute/edit for a DTS package?