Database Reference
In-Depth Information
Applying role-based security to custom
reports
Microsoft SQL Reporting Services has a security delegation model that you can apply to all
the reports that you create. System Center 2012 R2 Configuration Manager introduced
role-based security on the default reports. This role-based security model ensures that when
running reports, the user can only see objects that they have been granted access to view.
The delegation does not, however, extend to custom reports you create. You must secure
these reports using the standard SSRS model. This recipe shows you how you can modify
your custom reports to comply with and use the new security model introduced with the
2012 R2 version on the Configuration Manager.
