Delete All Users from NAV 2013 – SQL

,

Delete All Users from NAV 2013 – SQL

Sometimes we will need to delete all of our users from a NAV 2013 database as we may inadvertantly lock ourselves out or experiences glitches with user accounts. A quick way to delete all users from NAV 2013 is to do the following: 
1. Open SQL Server Management Studio. 
2. New Query (select the database we want to remove all the users from). 

3. Use the query below >> Hit Execute

delete
from
[dbo].[User]
delete
from
[dbo].[Access Control]
delete
from
[dbo].[User Property]


delete
from
[dbo].[Page Data Personalization]
delete from
[dbo].[User Default Style Sheet]
delete from
[dbo].[User Metadata]
delete from
[dbo].[User Personalization]

The following two tabs change content below.

Andy, Software Engineer

Andy is Software Engineer at Metaphorix