Permissions needed to create DTS

• Martin Balbo

  SSC Eights!

  Points: 824

  More actions

  October 25, 2005 at 10:16 am

  #115470

  Hi List, nowadays, i have some developers with SA role in a SQL2000 SP3 developement server.

  For security reasons i want to take off this privileges, but the problem is how can i assign them permissions to create / manage DTS, anyone knows the name of the SP (I suppose in master and model database) that i need to grant execute to the developers team?

   

  Thanks al...

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  October 25, 2005 at 12:52 pm

  #599913

  The permissions to manage DTS Packages should have already been granted to public (i.e. everyone). To confirm, run

  exec msdb.dbo.sp_helprotect @username = 'public'

  The output should include execute rights for stored procedures

  sp_add_dtspackage, sp_drop_dtspackage and sp_get_dtspackage

  amoung others.

  SQL = Scarcely Qualifies as a Language