1

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.

Rob C
  • 150
  • 2
  • 14

1 Answers1

2

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

Alan Schofield
  • 19,839
  • 3
  • 22
  • 35
  • What do I do if SSRS is installed on the same instance as the database engine? – Rob C May 25 '22 at 20:33
  • Nevermind. I figured it out. I never connected to anything other than a database engine before so connecting to Reporting Services was new to me. I will try out your suggestion. Thanks! – Rob C May 25 '22 at 20:50
  • I tested out the custom permission and it works perfectly! Thank you! – Rob C May 27 '22 at 15:35