Secure Shared Data Source Items

 

Applies To: SQL Server 2016

You can set security on a shared data source item to enable or disable access to it.

A user who has minimal access to a shared data source (for example, the access granted through the Browser role) can view the list of reports that use the item, provided the user is also authorized to view the reports themselves.

A user who has additional access (such as that granted through the Content Manager role) can view and set properties for the shared data source.

To set security, you create a role assignment that specifies which user or group account has access to the shared data source. Users who have access to a shared data source item can change its name, description, connection string, or credential information.

When creating role assignments, use a role that has these tasks to assign appropriate permissions to users and groups.

Select this taskTo give users permission to
View data sourcesView the shared data source item in the folder hierarchy. Without this task, the item is not visible to users and they may not be aware that the data source is available.
Manage data sourcesView properties that specify the name, description, and connection information. This task is also used to display a shared data source item in the folder hierarchy. If you choose this task, you can omit the "View data sources" task.
Set security on itemsCreate and modify role assignments that control access to the shared data source. This task must be used with either "View data source" or "Manage data sources" tasks. If it is not, it has no effect because the user cannot select the item.

Manage Report Data Sources
Secure Folders
Secure Reports and Resources
Granting Permissions on a Native Mode Report Server
Store Credentials in a Reporting Services Data Source

Community Additions

ADD
Show: