3,065
Hi everyone,
Can anyone assist on how users can be deleted on Microsoft dynamics Navision 2017.
Your quick response will be appreciated.
Thank you
Disu Ridwan
*This post is locked for comments
In a Nutshell Normally I dont ever recommend to even open SQL in your live NAV DB. A wrong query will take you to disaster.
I too keep firing SQL Queries as anyhow it makes developers life easier but still it's never recommended.
Hi Everyone, I appreciate your contributions. It really help to decide what i wanted to do and how i was able to sort my self out with the provided answers above.
What prompted the above question asked by me was that, We upgraded our client Microsoft Dynamics NAV 2009 to Microsoft Dynamics NAV 2017. The upgrade was done on our own test server with the client data. After we succeeded in upgrade, We decided to take the database to the client server and restored. We had lot of challenges at the point of restoring the database but we were able to sort that out. The 2017 NAV was lunched successfully on the client server. We pushed all client installation of Microsoft dynamics NAV 2017 on client system, but the client were not able to work on some modules with error messages pooping up.
We discover that some users on Microsoft dynamics NAV 2017 names where not showing, it was only showing the SID number.
That is the main reason why i decided to delete some users fron SQL and create them back on Microsoft dynamics NAV 2017. With the following procedure of deleting from SQL and creating them and also assigning the permission on Microsoft dynamics NAV 2017 makes the users able to work perfectly on the different modules they wanted to work on.
I appreciate all your support and quick responses.
Thank you all
Disu Ridwan Ayodeji
hi,
if the user has created documents, did some posting or what ever, then it's no good idea to remove it, because the user is saved in many tables and records. in that case it's not possible to remove the user from within dynamics nav. you could only remove it directly in the database using ssms or sql.
better set the user to disabled in nav and/or disable the AD-user.
Hello,
Agree with #Alexander But still you want to delete the users then use SQL Server queries.
Ex:
USE [NAV2016]
GO
DELETE FROM [dbo].[User]
WHERE [User Name] = 'CHALLANGER\BINESH'
GO
Or you can also use powershell, something like:
This example deletes a Microsoft Dynamics NAV user from the database that is connected to the Microsoft Dynamics NAV Server server instance that has the name MicrosoftDynamicsNavServer. The user is identified by the security identifier.
-------------------------- EXAMPLE 1 --------------------------
C:\PS>Remove-NAVServerUser MicrosoftDynamicsNavServer –WindowsAccount cronus\chris
I strongly advice not to delete users, but rather block them in Active Directory. User logins are stored and used in posted history documents that those users had created, which might be useful to refer to some day.
you can delete from SQL Server.
#1
André Arnaud de Cal...
292,489
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
