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?