Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS execute permissions Expand / Collapse
Author
Message
Posted Wednesday, June 03, 2009 9:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, February 10, 2014 6:01 AM
Points: 37, Visits: 347
Hi

I would like to know what permissions or roles would need to be granted to a user inorder to execute a dts. I do not wan't to grant the user system admin rights on the sql box; they should just be able to execute a dts from Enterprise manager and not be able to edit or modify any dts

Thanks
Post #728323
Posted Wednesday, June 03, 2009 12:58 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:14 AM
Points: 4,056, Visits: 5,181
See my reply here: http://www.sqlservercentral.com/Forums/Topic728068-146-1.aspx

Greg
Post #728464
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse