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

Get Microsoft® SQL Server® 2008 Reporting Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.