Report Builder and Report Model Security
Security is not limited to running reports in RB3. When you save a report to the catalog, users can access it through Report Manager. A user who has permissions to view a report but doesn’t have permissions to one of its fields simply will not see that column when running the report. This powerful feature is called column subsetting and is specific to reports using RMs.
Several resources are independently secured when you run reports in the Report Server:
• You can secure the report itself, by setting permissions on the report or inheriting permissions from the parent folder or the parent’s parent, and so on, all the way up to the Report Server root folder.
• You can secure the model in the Report Server; ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
