Post reply

Create, Modify, Exec DTS

  • September 16, 2003 at 3:32 pm

    #107192

    Is there a way I can give my developers a way to create, edit and exec DTS pkg's w/out giving them admin rights?


    Aurora

  • September 16, 2003 at 5:21 pm

    #474533

    Is this a development, or non-production, server? If so, then just give them dbo access to msdb that should cover things. I've played around giving more restrictive access but always found that there was some extra stored procedure, function or table that needed additional privelages assigned. Then it became too much like micro-management.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 18, 2003 at 8:11 am

    #474874

    Thanks Phill, that just may work. This is definitely a development environment.


    Aurora

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

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