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]