Restore NAV in different domain and keeping users permision and personalizations

KTA8KTA8 Member Posts: 397
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]

Best Answer

  • KTA8KTA8 Member Posts: 397
    Answer ✓
    I was a problem with the ID, the concept is OK

Answers

  • KTA8KTA8 Member Posts: 397
    Answer ✓
    I was a problem with the ID, the concept is OK
Sign In or Register to comment.