Open Forum

Expand all | Collapse all

Permissions on Item Table

Jump to Best Answer
  • 1.  Permissions on Item Table

    TOP CONTRIBUTOR
    Posted 9 days ago
    ​I came across a wierd fact today in NAV2013.
    Most postings and functions need "Modify" on the Item table to work.
    I was going to try and restrict more users from being able to edit Items but it seems I can't.

    I also found this thread: https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/137093/you-do-not-have-permission-to-modify-the-items-table

    Does anyone know if this issue is still present in the latest versions on NAV?

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------


  • 2.  RE: Permissions on Item Table
    Best Answer

    TOP CONTRIBUTOR
    Posted 9 days ago
    ​Hello Samuel,

    Interesting timing on your post.  I thought I remembered this as an issue, but we have been reviewing segregation of duties lately, so two weeks ago I changed all Modify's on the item table 27 from YES to INDIRECT on all permission sets except for one permission set call ITEM CARD-FULL which allows full direct access to insert, modify, and delete from the Item table.

    I've only had one user complain that she could no longer make changes.  I checked and she never had the ITEM CARD-FULL permission set, but was previously being allowed Modify access through another permission set for Transfer Orders.  Since I made the changes, she could still process Transfer Orders, but could not make changes directly to the Items.  I've since given her full access.

    No one else has had any issues, so it looks like INDIRECT modify permissions are working as advertised.

    We're currently running #NAV2013R2.





    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/BCUG Summit (navugsummit.com)
    Orlando, FL - October 15-18, 2019
    ------------------------------



  • 3.  RE: Permissions on Item Table

    TOP CONTRIBUTOR
    Posted 9 days ago
    ​Thank you Lewis, we are still on NAV2013 (not R2), maybe they fixed that then.
    Our re-implementation is on NAV2018 so we should be fine.

    Thanks!

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------



  • 4.  RE: Permissions on Item Table

    SILVER CONTRIBUTOR
    Posted 8 days ago
    ​Indirect Permissions can be a bit tricky to figure out.  I didn't learn this from my VAR until I was well underway setting ours up too, so I'm certain I have some areas with Insert or Modify that I'd rather have as indirect but who has the time to try and figure that out....

    But I digress.   If you change a permission to indirect and it does work, you need to turn on the debugger for that user's session and have them try again.  When the error occurs the debugger will show you the place in the code that the permission is failing.  It is typically another object that needs permission to write or modify the affected table.  It could be a table or code unit.  I can't modify code units, so if that is the case I tell my VAR what code unit needs permission to modify which table and they take care of it.  If it's a table, I can go into object designer and modify the table permissions and give it permission on the table.  Then the users should be able to use the indirect permission.

    Here is a print screen on what that looks like in Object designer.  Let me know if you need more thorough instructions.



    ------------------------------
    Brian Stenglein
    Clow Stamping Company
    Merrifield MN
    ------------------------------



  • 5.  RE: Permissions on Item Table

    TOP CONTRIBUTOR
    Posted 7 days ago
    ​Thank you Brian, that's insightful!

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role