I've read a few articles online but I cannot find a solution. I have SSRS users that are going to be migrated to another domain and they require access to the same SSRS reports once the migration is completed.
Example, user AbbyA on domain ABCD is going to be migrated to domain EFGH.
Old domain\username: ABCD\AbbyA
New domain\username: EFGH\AbbyA
I have the following code which allows me to see what reports users currently have access too:
select C.UserName, D.RoleName, D.[Description] [Description], E.[Path] [Path], E.[Name] [Name]
from [ReportServer].[dbo].[PolicyUserRole] A
inner join [ReportServer].[dbo].[Policies] B on A.PolicyID = B.PolicyID
inner join [ReportServer].[dbo].[Users] C on A.UserID = C.UserID
inner join [ReportServer].[dbo].[Roles] D on A.RoleID = D.RoleID
inner join [ReportServer].[dbo].[Catalog] E on A.PolicyID = E.PolicyID
where C.UserName = 'ABCD\AbbyA'
Can this be done via SQL Management Studio? Most of the articles I've read suggests that it cannot be done via SQL Management Studio, please do advise what my options are?