Can I create a custom role in Sql Server Reporting Services (SSRS) (2019)?

Viewed 135

I would like to create a custom role to mimic 'Browser', but not give the user access to subscribe to reports. I noticed that there is a 'Roles' table in the ReportServer database that lists out the current roles, along with a TaskMask and RoleFlags column. I do not want to attempt to tweak any of these columns b/c I don't know how they work.

1 Answers

You create roles via SSMS. Connect to the reportserver instance rather than the usual database engine.

enter image description here

Just right-click 'Roles' and add a new role. As you can see I added a "folder browser only" role previously.

When you create you new role you can exclude the highlighted option.

enter image description here

Related