Home > Forum > Database > Issue with UPN Change Affecting Record and Report Visibility

Issue with UPN Change Affecting Record and Report Visibility
0

Hello!

We recently had an issue where the UserPrincipalName (UPN) of Active Directory users was changed, which is causing problems with Webcon. The system uses the UserPrincipalName in the ‘CreatedBy’ field to track who created each instance. As a result, users can no longer see the instances they created before their UPN was changed.
One way to fix this is by manually updating the CreatedBy field for each record, but this is very time-consuming. Additionally, users can't see their previously created reports either, since those are also tied to the CreatedBy field. To restore access, we would need to update this field in the database as well.
However, doing this manually for each user and each record is not ideal, and there may be other tables in the database that also use the old UPN information. #

Is there a simpler or more automated way to handle this issue?

MVP

Hi Celina,
this topic have been throughly coverd on the forum a few times, to sum it up:
1. You could ask Webcon Support to provide updated dbo.ReplaceLogins stored procedure (it was on the db on older versions of the platform, it's no longer created on new instances and it's not updated):
* https://community.webcon.com/forum/thread/1466?messageid=1466
* https://community.webcon.com/forum/thread/2471
2. You can use Permission Migration tool in Administration Tools:
* https://docs.webcon.com/docs/2025R2/Studio/AdminTools/#permissions-migration
3. As Michał suggested - you should file a support ticket, and Webcon will handle it:
* https://community.webcon.com/forum/thread/7300?messageid=7300
4. There is and API endpoint which you could call "/api/studio/db/1/replacesecurities":
* https://community.webcon.com/forum/thread/7738