SSRS Security
If a person is a System Administrator in SSRS 2008 R2 why do you have to add them to all folders and reports?
November 25th, 2010 3:31am

Hi MontyPython, In SQL Server Reporting Services(SSRS), there are two different security roles, System Role and Item role. System Role contains a system-level task. A system-level task is a collection of permissions that relate to operations that apply to the report server site as a whole. An item-level task is a collection of permissions that relate to a report, folder, report model, resource, or shared data source. According to the description above, when a person is a System Administrator, he/she still need permissions to access individual item in the report server. Item permissions can be inherited. If reports or subfolders inherit permissions from parent folder, we don't need to set permissions for the reports or subfolders again. For more information, please see: System-Level Tasks: http://msdn.microsoft.com/en-us/library/ms157353.aspx Item-Level Tasks: http://msdn.microsoft.com/en-us/library/ms160344.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2010 5:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics