O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

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:

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

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