Post reply

DTS Security

  • May 10, 2007 at 4:11 pm

    #95303

    What is the min level of security you need to create and save a DTS package to a server? Do you have to be a member of sysadmin to do this?

    Thanks!

     

  • May 10, 2007 at 5:08 pm

    #705683

    Hi Carol,

    It depends on the security settings in msdb, particularly EXECUTE permissions on stored procedures that work with DTS packages i.e. sp_add_dtspackage, sp_drop_dtspackage, sp_enum_dtspackages, etc. 

    My suggestion is to go to the sqlservercentral home page and search for "DTS security".  You'll find lots of articles and forum threads discussing the particulars.

    Greg

    Greg

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply