I think I've done it before but I can't do it now. I'm able to change and make it work chaging the user but I need to delete the personalization to enter.
I can enter running:
update ["NAV database"].[dbo].[User] set [User Name]='"new domain"\"user"' where [User Name]='"old domain"\"user"'
update ["NAV database"].[dbo].[User] set [Windows Security ID]='"new ID"' where [User Name]='"new domain"\"user"'
truncate table [Access Control]
truncate table [User Property]
truncate table [User Metadata]
truncate table [User Personalization]
0
Answers