O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

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

Creating new roles in Reporting Services

As you saw in the previous recipe, SSRS comes with an array of predefined roles that should meet the needs of most of your users. You may, however, find situations in which the predefined roles are not quite right for your needs. SSRS allows you to create new roles, in which you may tune the permissions to suit your needs.

Getting ready

Adding new roles is not done through the Report Portal, as you might expect. Instead, it is handled within SQL Server Management Studio. You must have administrative rights to the reporting server to create new roles.

How to do it...

  1. Open SQL Server Management Studio.
  2. Connect to the instance of Reporting Services you wish to add new roles to.
  3. Expand the Security branch.
  4. Right-click ...

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