I have a prod support request from a high value user to adjust the settings on a company-wide dashboard so that he can manage a section of his workflow currently being excluded from these reports. Given the two immediately obvious options of
- altering the dashboard settings for ALL users company-wide or
- replicating the dashboard for HVU only
...it was decided that I should create a "dev" instance where HVU can see a variant of his dashboard. To accomplish this, I ported the
.rdl family to another
ReportServer instance in an identical directory tree & cloned all the stored procedures in the pertinent datasets from
Question: the stored procedures & security schema all exist on the same server & database so there's no risk of orphan users. Is it possible / what's the best way to clone all current user permissions from
Schema1_dev other than checking through the SSMS GUI?