Dynamics NAV permissions can be either a very simple topic (if you need to add a table permissions to existing security setup), or a very complex one (if you need to create security roles/permissions from scratch for the first time).
In case of missing Dynamics NAV permissions, users will be getting error messages saying “You do not have permission to read/modify … table”:
And it is quite easy to resolve such issue. All you need to do, is –
1) find which roles already have this permission and
2) add the missing role to user roles.
Find which roles already have this permission.
Click Tools > Security > Roles.
Click Role > Permissions.
Click Show All (or Shift+Ctrl+F7).
Click on Object Name column, then click Field Filter (or F7)
and enter the table name (in our example, it was General Ledger Setup)
This will show us a screen of all permissions/roles where table has been used. You will notice, that ROLE column is not visible by default, but we can add it by right-clicking on the “Object Type” column, and clicking on Show Column
Click on “Role ID” to put a checkmark (to select the field) and
click OK to come back to the list of permissions.
So, you have found out which roles already have the permission to read “General Ledger Setup” table. Now, we need to add the missing role for the user who was getting the error message.
Add the missing role to user roles.
Click Tools > Security > Database Logins (or Windows Logins)
Find your user who reported that he is getting permissions error. Click Roles.
Add the missing role. In this example, User1 had only 1 role, and did not have ALL role, so we will add “ALL” to user roles. Please note, that every user you create in Dynamics NAV, should have ALL role added to their security settings.
After adding missing roles, click Tools > Security > Synchronize All Logins
and ask user to try running through the same functionality again, to see if permission error issue has been fixed.