Post reply

can dbcreator create/alter ssis package?

  • January 14, 2011 at 9:18 am

    #230248

    Can 'dbcreator' create/alter SSIS package and schedule to run it?

  • January 14, 2011 at 9:35 am

    #1273633

    No. Having dbcreator only gives permissions to ALTER ANY DATABASE (meaning create/delete, too). This gives no permissions to create/alter SSIS packages stored in SQL Server or to schedule them for execution. The SQLAgent* roles manage job permissions. The db_ssis* roles manage SSIS packages stored in msdb. Both of the latter set of roles is found in the msdb database.

    K. Brian Kelley
    @kbriankelley

  • January 14, 2011 at 9:47 am

    #1273647

    Thank you very much for quick response.

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

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