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 |
dbthj
Posting Yak Master
143 Posts |
Posted - 2007-08-29 : 13:38:59
|
The application and database was run by programmers. Everybody created their own DTS packages. Now the owner of the application wants to give delete authority on DTS packages to a few ids. I don't see any way to do that without making them sysadmins. I tried wrapping sp_reassign_dtspackageowner inside another sp and granting execute on it. That fails. Anybody got a clue how to give a non-admin authority to delete a package created by the programmer that went bye-bye without my reassigning owner for him? |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 01:20:17
|
You can play with permissions in msdb, I did it before but don't have sql2k server to check with now. |
|
|
dbthj
Posting Yak Master
143 Posts |
Posted - 2007-08-30 : 09:03:02
|
Can you recall what sort of permissions you played with?Were they mere grants? Or some sort of system table skullduggery? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 00:29:12
|
Grant exec permission on certain sps in msdb. |
|
|
dbthj
Posting Yak Master
143 Posts |
Posted - 2007-08-31 : 09:08:56
|
Nope. You can't grant execute on sp_reassign_dtspackageowner to anybody. It canonly be executed by the owner or a sysadmin. |
|
|
|
|
|