[Script of Nov 16th] Add one user/group to one specified Reporting Services item in SQL Server

  • Article

Script Download: addpolicy.zip https://gallery.technet.microsoft.com/scriptcenter/Add-one-usergroup-to-one-59b89695

This Visual Basic.NET sample script illustrates how to add one user or one group to a SQL Server Reporting Services item by referencing SSRS web services. This script applies to SQL Server Reporting Services 2005, 2008, 2008 R2 and 2012 versions in native mode.

Add a user or a group and grant certain permission on specify item is one question frequently meet in Reporting Services administration. Traditionally, IT professionals can finish this task in Report Manager web site. Actually, using one rss script with variables can also achieve the same effect as using UI.

 

image image
image image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery