Departments Menu Glitch - NAV 2009 / R2

Departments Menu Glitch - Assign Users 

In Navision 2009 / R2 (Classic) you are able to hide departments from your users, however somtimes this can glitch. I've witnessed this issue a few times whereby the you disable / enable a department for a user but nothing happens.

The quick fix is to delete the user completely from NAV.

Tools >> Security >> Windows/Database Logins >> Copy all the permissions >> Delete the User >> Synchronize >> Re-Add the user >> Paste the logins back in >> Synchronize.

As to why this happens, I have no idea. I think the 'User Menu Level' gets corrupted.

 

 

Delete All Users from NAV 2015

Delete All Users from NAV 2015 - SQL

Note: This same script can be used on NAV 2013/NAV 2013 R2

Sometimes we will need to delete all of our users from a NAV 2015 database as we may inadvertantly lock ourselves out or experiences glitches with user accounts. A quick way to delete all users from NAV 2015 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]

NAS Manual Install

NAS Service Install

(NAV Application Server)

"C:\Program Files (x86)\Microsoft Dynamics NAV\60\Application Server\nassql.exe" appservername="Application Server", NETTYPE=TCP, servername="SQL-SERVER", database="Cronus 2009 R2", company="CRONUS Ltd.", nettype=tcp, startupparameter="JOBQUEUE", objectcache=40000, installasservice

The configuration for this can be ammended in the registry if you dont have the MMC snap in installed. 

HKEY_LOCAL_MACHINE/SYSTEM/CurrentConotrolSet/Services