SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Package Administration
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbthj
Posting Yak Master

143 Posts

Posted - 08/29/2007 :  13:38:59  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/30/2007 :  01:20:17  Show Profile  Reply with Quote
You can play with permissions in msdb, I did it before but don't have sql2k server to check with now.
Go to Top of Page

dbthj
Posting Yak Master

143 Posts

Posted - 08/30/2007 :  09:03:02  Show Profile  Reply with Quote
Can you recall what sort of permissions you played with?
Were they mere grants? Or some sort of system table skullduggery?
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/31/2007 :  00:29:12  Show Profile  Reply with Quote
Grant exec permission on certain sps in msdb.
Go to Top of Page

dbthj
Posting Yak Master

143 Posts

Posted - 08/31/2007 :  09:08:56  Show Profile  Reply with Quote
Nope. You can't grant execute on sp_reassign_dtspackageowner to anybody. It can
only be executed by the owner or a sysadmin.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000