Item Level Role permissions in SSRS 2008

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.

6 thoughts on “Item Level Role permissions in SSRS 2008

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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s