0

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

My View

This is what they see

enter image description here

Thanks!

0

The only way we were able to find a way around this was to grant the user SysAdmin rights. Even with CONTROL at the server level, it is not available.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.