Working with Report Manager - Learning SQL Server Reporting Services 2012 - page 192

Hands-on exercise 4.4 - creating a permission
to a specific report
The Home folder is at the root and the rest of the folders come under it. Folders may
have subfolders and they in turn can have subfolders. That's the hierarchy. Permissions
are inheritance based. A folder directly under Home inherits the permission from Home .
However, the security of the folder can be edited. You may be warned at that time that
you are changing the security from the default. This way we can set the permission to
a folder/file.

In an earlier hands-on exercise, we created a subfolder to which we moved a folder
containing a report. The report FromSSDT_OrderDetails is in the hierarchy Home |
Main_Feb19 | Sub_Feb19 | Feb19 | FromSSDT_OrderDetails.rdl .

1. Presently the folders Main_Feb19 , Sub_Feb19 , February19 , and FromSSDT_

OrderDetails all have the Content Manager permission.

2. We now change the permissions to the Main_Feb19 folder and because

of inheritance it will be conferred to the report.

3. Click on Edit in the Main_Feb19 folder's Security page. The Edit Role

Assignment page is displayed.