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];  

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

 Enjoy.
Advertisements

One comment on “NAV 2013 – Open as a Fresh User with Default Settings.

  1. Pingback: Make NAV User – SQL + PowerShell | Research – Develop – Share – Repeat

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s