I am trying to grant access to allow users to view and update existing legacy DTS packages. The problem is that they cannot see the needed nodes under Management to begin working on them. I've tried granting every possible permission, including making them db_owners of the MSDB but nothing so far has worked. If I grant CONTROL at the server level the nodes become visible but this is certainly not a sustainable set of permissions.
Attached are 2 images. One of the nodes as I see them as one as they seem them. I've prowled around the web trying to identify the minimum rights needed but have so far not come up with the right formula.
Does anyone know what the minimum rights for this process are or am I stuck making them temporary super-users?
This is what I see
This is what they see
Thanks!


Asked by PseudoToad
(838 rep)
Jul 29, 2015, 04:01 PM
Last activity: Aug 11, 2015, 05:24 PM
Last activity: Aug 11, 2015, 05:24 PM