9
A customer (MBS Navision 4.0 SP3, native database) has changed the ADMIN password with SUPER USER authorizations.
Now this password is lost/forgotten.
This was the only user with SUPER USER authorizations.
This happened a few weeks ago, so restoring backup is no option.
Database verification login.
Is there a way to retrieve the password?
Version is NAV 4, but I could not insert below.
Thanks in advance for your input.
Sorry I'm not sure if this will work in Navision 4.0.
If you have access to the database, you can clear all users, and then when you open the environment, the first logged-in user will automatically become the Super user.
https://www.navuser.com/sql-query-to-delete-all-user-data-for-rtc-versions-of-dynamics-nav/
USE [Database 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]
Hope this helps.
Thanks.
ZHU
#1
André Arnaud de Cal...
293,280
Super User 2025 Season 1
#2
Martin Dráb
232,034
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
