SQL Server Developer Center > SQL Server Forums > SQL Server Reporting Services > SSRS 'Browser and 'Content Manager role' default settings
Ask a questionAsk a question
 

AnswerSSRS 'Browser and 'Content Manager role' default settings

  • Monday, November 02, 2009 11:51 AMMr Shaw Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I am setting up the roles in Report Services and I need return everything to the default settings.

    For 'Browser' I have selected Consume reports and View Reports.

    For 'Content Manager' everything has been selected.

    What are the default settings for these two roles?
    Mr Shaw

Answers

  • Wednesday, November 04, 2009 4:17 AMJerry NeeMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi Shaw,

    Please read this article http://msdn.microsoft.com/en-us/library/ms157363.aspx for more details on the predefined role in reporting serivces. These roles are defined once finishing installing the reporting service, and you also can change their tasks as you want or your requirement or new a custom role to use. For Browser role, Microsoft defines it to view folders, reports and subscribe to reports but can't read report definitions(we called consume reports tasks), so the Consume reports tasks is not selected in Browser role by default. But you also can select it for browser if it's required in your report project.

    How to modify the tasks of these predefined roles: In SQL Server Management Studio, connect your Reporting Service->expand Security note->expand Role note  then double click any role you want to re-select their tasks in the tasks list. If you are using SSRS 2005, it also can be do in Reporting Manager->Site settings->Security section->Configure Item-Level role definition

    Helpful links:  http://msdn.microsoft.com/en-us/library/ms156293.aspx for how to create, delete and modify the role in reporting services 2008.

    Please let me know if you have more question.

    thanks,
    Jerry

All Replies

  • Monday, November 02, 2009 12:40 PMSatBI Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    Hi Shaw,

    For Browser the default Settings are : 
                                               Manage individual subscriptions
                                               View folders
                                               View models
                                               View reports
                                               View resources

    For "Content Manager" the settings are correct. Everything should be selected.

    Thanks,


    SatBI http://Satishsharing.blogspot.com
  • Monday, November 02, 2009 12:49 PMMr Shaw Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Why is Consume reports not selected in Browser?
    Mr Shaw
  • Wednesday, November 04, 2009 4:17 AMJerry NeeMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi Shaw,

    Please read this article http://msdn.microsoft.com/en-us/library/ms157363.aspx for more details on the predefined role in reporting serivces. These roles are defined once finishing installing the reporting service, and you also can change their tasks as you want or your requirement or new a custom role to use. For Browser role, Microsoft defines it to view folders, reports and subscribe to reports but can't read report definitions(we called consume reports tasks), so the Consume reports tasks is not selected in Browser role by default. But you also can select it for browser if it's required in your report project.

    How to modify the tasks of these predefined roles: In SQL Server Management Studio, connect your Reporting Service->expand Security note->expand Role note  then double click any role you want to re-select their tasks in the tasks list. If you are using SSRS 2005, it also can be do in Reporting Manager->Site settings->Security section->Configure Item-Level role definition

    Helpful links:  http://msdn.microsoft.com/en-us/library/ms156293.aspx for how to create, delete and modify the role in reporting services 2008.

    Please let me know if you have more question.

    thanks,
    Jerry