Fixed database-level roles

There are three fixed database-level roles for Integration Services 2012 that are very similar to those available in SSIS 2005 and 2008. You may be wondering why you didn't spot them when we added our user to the ssis_admin role, but that is because they only exist in the msdb database rather than the SSISDB database we created.

These roles, db_ssisadmin, db_ssisltduser and db_ssisoperator allow you to manage user access to your SSIS packages. To add a user to these roles from SSMS:

  1. Expand the Security node in Object Explorer.
  2. Expand the Logins node.
  3. Double-click on the login you want to edit, which brings up the Login Properties window:
  4. Make sure the login has access to the msdb database and then select the three roles in ...

Get What's New in SQL Server 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial