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