DTS permissions

Last Post 15 Feb 2006 07:23 AM by PaulMcKibben. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
New Member
New Member

--
14 Feb 2006 11:34 AM
I have a new VB developer that is modifying DTS packages as a part of her job. She currently has access to the databases that she needs.

When editing a DTS package that she did not create, she get a OLE DB Provider error that states she has to own the DTS package or be a member of the sysadmin role.

I would prefer not to give her sysadmin authority. If I create a role, what kind of authority would that role need?

Thank you
PaulMcKibben
New Member
New Member

--
15 Feb 2006 07:23 AM
With SP_CHANGEOBJECTOWNER, the DTS package name, and her user-id, correct?
You are not authorized to post a reply.

Acceptable Use Policy