Hi I am using NAV 2017, is there any way to copy user personalization from one user to another?
Please help me.
I have been struggling with the same issue, and found this blog post from Roberto Stefanetti :
It can be done with a SQL Query :
INSERT into [DATABASE].[dbo].[User Metadata]
([User SID],[Page ID],[Personalization ID],[Date],[Time],[Page Metadata Delta])
a.[Page Metadata Delta]
FROM [DATABASE].[dbo].[User Metadata] a
WHERE a.[User SID] = 'S****'
[User SID] = ‘S****’ , Replace the SID with the SID of one USER.
It worked for me on NAV 2017 with no side effect so far, but in my opinion, it is never a good idea to modify data directly in the SQL database, so be careful.
Have a good day !