Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Let say that some time ago the user "userA" (created in our Active Directory) was authorized to access a report published on the Report Server.
Recently "userA" has been eliminated from the Active Directory. If I check the security of the report with the web portal, I can't see this user anymore, but it is still archived in the Report Server repository tables such as [ReportServer].[dbo].[Users], [ReportServer].[dbo].[PolicyUserRole], [ReportServer].[dbo].[Catalog].
If I would "cleanup" the repository tables removing these "orphaned" users, how could I do it without breaking anything?
Hi @Vosaxalo ,
Try to delete all rows in all tables with the same UserID. For the code, this post may help you:
Search for one value in any column of any table inside a database.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
User | Count |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
6 | |
4 | |
4 | |
3 | |
2 |