We are in the middle of an upgrade from NAV2013 to NAV2017. Everything is going pretty well, not too many issues. The only problem we have is around permissions.
During the upgrade we moved from self hosted to amazon hosted servers. We had to recreate all our users meaning that they now have a different Windows SID to what they used to be.
The only thing we did is revalidate the Windows User Name on the card. For most users this has worked fine but for some users we get permissions issues.
One user reported a problem saying that she couldn't modify an item, she had the permission group 'INVT-ITEM/BOM, EDIT' which in our system has full permissions on the item table so she shouldn't have got an error.
I then deleted that group and re-added it after which point she could edit the item but she lost the ability to edit the "Item Unit of Measure" table which, for us, is in the same permission groups with full permissions assigned to it.
Now I was under the impression that the Windows SID is only used on the user table and every other user related table is linked by the "User Security ID" field.
Any ideas what could be causing the permission issues?