sql-serverreporting-servicesreportserver

MSSQL Report Server reset all permissions

I'm currently running a Windows Server 2008-R2 with a MSSQL server and Reporting Services.

There are currently hundreds and hundreds of folders and reports, however the users all adjusted their security settings.

My question is: Can I reset all permissions on all folders and reports to have the same user permissions as the /Home folder without having to open them one by one? Or reset all permissions, create new ones on the /Home folder and let the other folders and reports inherit them?

Solution

  • You can use the API or directly change the SSRS data. The API is approved and safer. This article has some links that should get you started.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d9f1b807-0200-47c9-9ec6-dd5316db13cf/reset-all-security-policies?forum=sqlreportingservices