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

Authorizing users for accessing reports via SSRS roles

SSRS grants users permissions to various reports and folders in the Report Portal through Roles. You can assign either an individual user, or more commonly, an Active Directory group, to a role. In this recipe, we'll explore the various roles built into SSRS and what rights are granted through those roles.

Getting ready

To grant a user permission, you will need to have administrative privileges for the Report Portal. If you've not done so, ensure you first follow the steps in the previous recipe, Becoming a Report Portal System Administrator, or else the steps in this recipe (as well as the remaining ones in the chapter) will not work.

How to do it...

  1. Navigate to the Home folder in Report Portal ...

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