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?
DTS Package Administration
Posted - 08/29/2007 : 13:38:59
