SSRS grant access to the user for multiple reports at once

Question

Hello, I need to grant access to the user for multiple reports at once, for example I always was granting access for the report to the users one by one manually, but now I need to create kind of role access. For example when I give to the user the access, it should contain many reports not only one. If anybody knows how to that, please help.

Answer 1

Hi @Shukran Mammadov

You don‘t need to create a role,Reporting Services installs with predefined roles : https://learn.microsoft.com/en-us/sql/reporting-services/security/role-definitions-predefined-roles?view=sql-server-ver16
If these roles do not meet your usage, you can create your own roles

In my opinion, your issue can be solved like this: MOVE multiple reports to a new folder, and then grant this user access to this folder, then this user can have access to all reports in this folder
My steps are as below，you can take a reference：

1.Create a new user in AD

2.Then open the report server web portal url in administrator account，create a newfolder ，and move the reports to this folder

3.Grant the new user have access to this folder

Then we can test if this new use have access to this folder，direct type in the folder url http://node1/reports/browse/newfolder login in by the new user account

We can see that all reports in this folder is visible

And if you can’t open the report due to the datasource access，you can change the datasource setting on the report

Best Regards,
Isabella

---

If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi there,

You can set up an Active Directory group per role and then associate the roles to the report folders. Then it's a matter of managing the AD groups' membership.

SSRS: How to set up the folder security roles in SQL Server Reporting Services https://social.technet.microsoft.com/wiki/contents/articles/40150.ssrs-how-to-setup-the-folder-security-roles-in-sql-server-reporting-services.aspx

Reporting Services uses role-based security to grant user access to a report server. On a new report server installation, only users who are members of the local Administrators group have permissions to report server content and operations.
https://learn.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-server?view=sql-server-ver16

----------------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept it as an answer–