I'm new to Powershell. But I need to find out whether it is possible to mimic a user's permissions on different SSRS reports (as some of these users have permissions to hundreds of reports) and grant these permissions to other AD users. I looked online, but haven't been able to find anything that can do that..yet. Was wondering if this is possible at all.
Asked
Active
Viewed 245 times
1
-
Are you using active directory groups for folder security? – aduguid Apr 16 '22 at 12:26
-
Active Dir groups, yes. – imranH2018 Apr 19 '22 at 16:42
-
I decided to create a stored proc that takes two parameters - the ID to be copied and the ID to be assigned permissions. And the stored proc returns a powershell function and the script to apply the permissions on the folders. So I copy and paste the results from the stored proc directly to powershell and it applies all the permissions to the ID. Not a one step solution but two. – imranH2018 Apr 21 '22 at 18:02
-
Would you mind sharing that stored proc? I need to do the same – Emo Aug 03 '22 at 20:43