web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / TharangaC - Microsoft Dynamics Business Central... / Reset NAV 2013 or 2013 R2 s...

Reset NAV 2013 or 2013 R2 security and settings

Views (1353)
Tharanga Chandrasekara Profile Picture Tharanga Chandrasekara 23,118
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

This was originally posted here.

Comments

*This post is locked for comments