SSRS 2008 provides a number of default item-level roles, listed here:
|
Browser |
May view folders, reports and subscribe to reports. |
|
Content Manager |
May manage content in the Report Server. This includes folders, reports and resources. |
|
My Reports |
May publish reports and linked reports; manage folders, reports and resources in a users ‘My Reports’ folder. |
|
Publisher |
May publish reports and linked reports to the Report Server. |
|
Report Builder |
May view report definitions. |
The individual permissions of each role can be found in the following table. Hopefully this will help to see the increasing progression of permissions ascribed to each role.
|
Browser |
Publisher |
Report Builder |
My Reports |
Content Manager |
|
|
Consume Reports |
Yes |
Yes |
|||
|
Create Linked Reports |
Yes |
Yes |
Yes |
||
|
Manage All Subscriptions |
Yes |
||||
|
Manage data sources |
Yes |
Yes |
Yes |
||
|
Manage folders |
Yes |
Yes |
Yes |
||
|
Manage individual subscriptions |
Yes |
Yes |
Yes |
Yes |
|
|
Manage Models |
Yes |
Yes |
|||
|
Manage Report History |
Yes |
Yes |
|||
|
Manage Reports |
Yes |
Yes |
Yes |
||
|
Manage Resources |
Yes |
Yes |
Yes |
||
|
Set Security for Individual Items |
Yes |
||||
|
View Data Sources |
Yes |
Yes |
|||
|
View Folders |
Yes |
Yes |
Yes |
Yes |
|
|
View Models |
Yes |
Yes |
|||
|
View Reports |
Yes |
Yes |
Yes |
Yes |
|
|
View Resources |
Yes |
Yes |
Yes |
Yes |
It is possible to create a custom role by copying an existing role, and modifying it. Note, however, that if you make amendments to the original role, this will not be cascaded to any amended copies of the role. To add this post to Twitter, please click here.
