Post reply

DTS privileges

  • February 5, 2004 at 4:34 am

    #160418

    Hi! I created a role for developers in a development database. The privs are create table,create view,create procedure. Can I grant them privilege to create packages,modify/save/run packages? How?

    Thanks!

  • February 6, 2004 at 9:09 am

    #493102

    You don't have to do anything.  All users should be able to create/modify/run their own DTS packages unless of course, you have revoked permission to all the DTS stored procedures in msdb.


    Joseph

  • February 6, 2004 at 2:29 pm

    #493166

    By default each SQL Server user has permissions to add, modify "their own" packages. Unfortunately, SQL Server does not have a default mechanism to allow developers to modify each others package without being a sysadmin. The only way, as some one had suggested in the forum before, was to tweak the sp_add_dtspackage procedure. I hope MS fixes it in the next version.

     

  • February 8, 2004 at 11:56 pm

    #493216

    Thanks a lot everyone!

Viewing 4 posts - 1 through 3 (of 3 total)

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