Aug 23

Reset NAV 2013 or 2013 R2 security and settings

If it is required to delete users, user properties, debugger breakpoints or session event related info; then use following TSQL code. It simply delete the data from the tables directly and allow you to use the NAV as a fresh settings. 

 USE [YourNAVDatabase];  
 delete FROM [dbo].[Access Control];  
 delete FROM [dbo].[User];  
 delete FROM [dbo].[User Property];  
 delete from dbo.[User Personalization];  
 delete from dbo.[User Metadata];  
 delete from dbo.[Page Data Personalization];


Thank you and Regards
Tharanga Chandrasekara

Click on a star to rate it!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

2 comments

    • Anonymous on October 20, 2017 at 1:48 am
    • #

    Excellent post. I ｃertainly love tһis site. Ⲕeep it սp!

    • Unknown on October 20, 2017 at 1:56 am
    • #

    Thank you for the feedback.

Comments have been disabled.