What Can Be Secured?


Although it might not be the most efficient approach, the reality is that just about every report item can be secured individually. Some things that don't follow this rule are subscriptions and schedules because they are used in conjunction with a report and not as an independent part of it. Table 18.1 describes how report items and their security work.

Table 18.1. Report Items and Effects of Security

Report Item

How Security Applies

Folder

Securing a folder usually ends up securing all the items within that folder. When SSRS is installed, only local administrators are Content Managers on the root folder. This ensures that no user can browse the catalog, unless given explicit rights to do so. The exception to this is the My Reports folder. My Reports, if it's enabled, creates a pseudofolder within the catalog in which users are given permissions to publish their own reports .

Report

Reports and linked reports can be secured to control levels of access. For example, the View Reports task allows users to view a report as well as report history, whereas Manage Reports allows them to change report properties. Manage Report History allows users to generate snapshots.

Model

Primarily used to secure access to the model, it can also be used to secure reports for which the model acts as a data source. Models can also be secured internally by securing model items with perspectives, specifying role assignments on all or part of a model, and securing items such as the root node, folders, entities, and relationships within the model.

Resources

Resources are items in the Report Server that provide content to user. An example of a resource can be an HTML file or Word document. Securing a resource limits access to the resource and its properties. The View Resources permissions are needed to access the resources.

Shared data sources

Securing shared data sources limits access to the data source and its corresponding properties. To view the data source properties, users need the View Data Sources permission; likewise Manage Data Sources gives permissions to modify them




Microsoft SQL Server 2005 Reporting Services
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net