Post reply

Permission to deploy and execute SSIS package

  • July 27, 2010 at 8:15 pm

    #223837

    Anyone know of a way to give a non-sysadmin account the ability to deploy and execute SSIS packages? Our developers need that level of access on our development server as they build and test their packages.

    Possible?

  • August 2, 2010 at 5:08 am

    #1200922

    Proxy account

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • August 2, 2010 at 5:35 am

    #1200930

    Try this (quote from BOL):

    SQL Server Integration Services includes the three fixed database-level roles, db_ssisadmin, db_ssisltduser, and db_ssisoperator, for controlling access to packages. Roles can be implemented only on packages that are saved to the msdb database in SQL Server. You assign roles to a package using SQL Server Management Studio. The role assignments are saved to the msdb database.

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

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