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?


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

    Excellent post. I certainly 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.