NAV 2013 – Open as a Fresh User with Default Settings.


Sometimes doing an operation from SQL side is much easier then exceuting it from NAV itself. If you want to use NAV as a fresh user with all default settings then you just need to execute a dell or truncate SQL command for these Tables

 USE [DBName]; 
 delete FROM [Access Control];  
 delete FROM [User];  
 delete FROM [User Property];  
 delete from [User Personalization];  
 delete from [User Metadata];  

 USE [DBName]; 
 Truncate Table [Access Control]; 
 Truncate Table [User]; 
 Truncate Table [User Property]; 
 Truncate Table [User Personalization]; 
 Truncate Table [User Metadata];