Delete Users from NAV / Business Central

Introduction: 

Have you received demo databases from someone? But you do not have the credentials?
Read below to find the details.

Pre-requisites: 

NAV / Business Central OnPermise

Demonstration: 

NOTE: This step is not recommended for Production Server unless you explicitly need to do so.

If you do not have Users in NAV/ Business Central, by default will allow you to add yourself as Administrator. This is needed if you migrate your database from one server to another outside of your AD.

1. Take SQL Backup:
You can take SQL Backup by visiting SSMS > Right Click on DB > Tasks > Back Up > Select the File.

Once you complete the wizard, your SQL backup file will be created.

2. Clear User Data using SQL Script:

You can clear the Users, clear User Personalization, clear Metadata, and other tables

USE [YOUR DB NAME] GO 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]

3. Create Users in NAV / Business Central:
Once all the Users are deleted, you can simply add your User in Business Central by going to Users > Add me as Administrator.

This will add your logged-in user as a Windows-based SUPER user.

Conclusion:

This blog contains information about deleting users using SQL Script and how you can add yourself as an administrator.
For any questions feel free to contact me at olisterr@outlook.com