November 5, 2001 at 6:36 pm
Hi all
I have a DTS package that was created by user XYZ (ie. saved to SQL*Server
under this sqlserver login). I have another user ABC that needs to alter
this package and therefore save off another version. Unfortunatly for me
SQLServer tells me that only the owner can do this or a member of sysadmin
group.
How can I share out the package to allow XYZ and ABC users to work on
the same DTS package???
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
November 5, 2001 at 10:52 pm
Never tried this. I do all the DTS work. I'll take a look.
One thing off the top of my head is to save as a COM file and allow someone else to modify it. They save it back to COM and let the original person reopen it. Kludgy, but would work.
Steve Jones
November 6, 2001 at 2:16 am
The DTS package can be modified by the owner only, you cant share it. Steves solution will also do.
November 6, 2001 at 6:59 pm
Hi guys
Another option (will try today), is to save as a VB package and allow users to alter via VB, its messy though.
In the end its fair enough based on SQLServers DTS data model. They have a "owner" col assoc with the package itself. A better plan was to allow some sort of role type security access to DTS's.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
November 7, 2001 at 11:14 am
VB is fine, but then you can't bring it back to the designer. This is fine if your people know VB.
Steve Jones
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply