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.
It is possible to create a custom role by copying an existing role, and modifying it.
How? Is this in SSMS or in the Site Settings of Report Manager?
Hi, I'm sorry I wasn't more clear. Here's some more info: http://msdn.microsoft.com/en-us/library/ms177283(SQL.90).aspx Basically if you
-open SSMS
-go to your SSAS database
-click 'Roles'
-right-click on the role you'd like to duplicate
-In the menu that appears, select 'duplicate'
Then you get a wizard that walks you creates a copy of the role for you, and then you can tweak it how you like.
I hope that helps a bit; I'm sorry I didn't provide more detail originally. Hope your day goes well,
Jen
Hi Jen,
I'd appreciate your thoughts on the do's and don'ts in SSRS/SSAS..
Regards,
Kalai.
Hi Kalai,
Thank you for your interest! I've started to write a series on SSAS for Technorati: I'll post the link up as soon as my latest post is edited and reviews.
Kind Regards,
Jen
Hi Kalai,
In response to your query, I've posted about some 'dos and don'ts' before starting an SSAS project.
HTH,
Jen
Hi Jen,
how come I don't see any links for managing Item-level roles etc? from the document, there are shoud have some links under the page of site settings of reporting service.
thanks
Henry