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 3, 2009 9:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 2:22 AM
Points: 37, Visits: 353
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 3, 2009 12:58 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 11:13 AM
Points: 4,064, Visits: 5,360
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