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
    • Reply

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

  1. Thank you for the feedback.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.