Microsoft® SQL Server 2012 Unleashed

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