Use SQL/PowerSheel script to add SSRS users with different access levels (Browers, Content Manager, Publisher etc.,)

  • Hello,

    I have a big list of users that I need to add to a few of my existing SSRS reports. I also need to keep this going for any future reports that I might develop. These users fall into different buckets based on the position in our org chart (some are Browsers, while others are content managers or Publishers). I have several reports, and the role of a user could vary from report to report. There are no set AD Roles which would have made my job easier. I was just wondering if there is any way for me to create a script (SQL to mess around with ReportServer and ReportServerTempDB tables; or a PowerShell script) which I can run directly. Given the number of users I need to add, any such script would make my job easier. I could directly read off of an excel spreadsheet and generate this script, which can passed on to our deployment team for quick addition of users to any new report(s). I tried to search around in the forum, but couldn't find any posts that match my requirement.

    Your help is highly appreciated in this regard.

    SQLCurious

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply