Overruling inherited access rights does not work properly

hello everybody,

i have encountered issue when tried overrule "home" level access rights on ssrs (verion 2009.0100.1600.01).

the situation there third party company has setup , edit reports. created folder them , edited security settings there. confirmed have different security settings on parent "home" level third party should not have access other reports.

i added user , assigned "content manager" role.

after able access folder, upload reports , data sources.

but: not able edit reports or sources. gets message:

the permissions granted user 'xy' insufficient performing operation. (rsaccessdenied) online help

i assigned roles did not help.

test showed if user has rights inherited "home" (added there content manager role) can edit reports uploaded. in case has access other folders (as inherit security settings "home").

is not possible ssrs set way planned? in advance help!

br,

karsten

hi karsten,

in reporting services, content manager role predefined role has full permission manage report server content, including ability grant permissions other users, , define folder structure storing reports , other items. contains manage data sources , manage reports tasks.

besides, if user has rights inherited "home”, have permissions inherited “home” permissions. if click “edit item security” button, can assign particular permissions user.

in scenario, seems had modify tasks predefined role in sql server management studio. please change back. in order allow user can access folder, should create role manage reports task in ssms, assign user role in parent folders. more details how create, delete, or modify role in sql server management studio, please see:
http://msdn.microsoft.com/en-in/library/ms156293.aspx

if there other questions, please feel free ask.

thanks,
katherine xiong

---

katherine xiong
technet community support

SQL Server  >  SQL Server Reporting Services, Power View