O'Reilly logo

What's New in SQL Server 2012 by Jon Reade, Rachel Clements

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required