It is possible to delete a user that do not exist anymore from the Report Server repository?

[Vosaxalo]

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?

[Icey]

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.