February 5, 2016 at 4:44 am
I am trying to get Folder/report permissions for all reports. I found a strange issue. In the results, I get a "username" (say Domainsame) having browser access. But, when i check the report/folder in SSRS URL, I dont see that id.
My guess is, this is because the users table does not have updated entries, even deleted UserName are there in the table.
Any idea is appreciated.
Background:
We migrated the server from Domain-1 to Domain-2 and after migration, we found that a person having,
Domain-1\Name got migrated to Domain-2\Name ID, resulting in 2 similar IDs. so, i am trying to find username, where both Domain IDs are already there for a report/folder. If i found such IDs, then I can remove one of them, before migrating it to Domain-2.
When I run my query to get permission, it gives below 2 records. But only one is valid.
Domain-1\testname
Domain-2\testname
select C.UserName, D.RoleName, D.Description, E.Path, E.Name
from dbo.PolicyUserRole A
inner join dbo.Policies B on A.PolicyID = B.PolicyID
inner join dbo.Users C on A.UserID = C.UserID
inner join dbo.Roles D on A.RoleID = D.RoleID
inner join dbo.Catalog E on A.PolicyID = E.PolicyID
order by C.UserName
February 7, 2016 at 12:10 pm
Guys, Any ideas?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply