O'Reilly logo

Microsoft® SQL Server® 2008 Reporting Services Step by Step by Stacia Misner

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

Implementing Data Security

It’s important to remember that giving a user access to a report does not necessarily mean that a user has access to the data retrieved by the dataset queries. If you’re using Windows integrated security, then you must also give users Read permission on the source data.

Furthermore, when you need to give users access to the same report but must manage how much data displays in the report for each user, you must implement data security. There are several ways to implement data security, but all methods achieve the same result. Consider, for example, the Reseller Sales Margin Analysis By Sales Territory report in the Sales folder. This report includes a parameter that allows the user to view data for all sales territories ...

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