Table Permissions for Limited Users

With Nav 2013 a new License Model was introduced. Especially the new Limited User License is a bit hard to understand. First of all: full read access is permitted. But … write access is very strong limited. It’s said, that within a write transaction 3 tables are allowed to access, But … it’s not described, how to do that. That is not easy to handle, especially for developers. 😦  But ok. It would be interesting, how the Microsoft Developers themselves handle that limitation.
What does that mean at the end? When writing your own code, always check your list of used tables. A maximum of only 3 tables, you use, might not be listed in “Appendix A”, within your code snippet!
At least there are a couple of tables, that can be used anyway. Following is the original text out from the “Dynamics ERP Perpetual License Guide”.

Limited User licenses for Microsoft Dynamics NAV 2013 provide users full read, but limited write capabilities to all of the licensed solution functionality through any and all modes of access including the Windows Client. The Limited User license is designed to give customers a lower-cost alternative for extending ERP to users who only need to perform the following tasks:

  • “Read access” to data contained in the ERP solution through any client accessing the application via the Microsoft Dynamics NAV Application Programming Interface (API) including but not limited to the User Interface Web Services for Microsoft Dynamics NAV
  • “Write access” via the Timesheet functionality
  • “Write access” through any client accessing the ERP solution via the Microsoft Dynamics NAV API to a maximum of 3 table objects in any range number with the following exceptions:
    • limited users are not allowed to write to any of the following tables: General Ledger (table 17), Permission Set (table 2000000004), Permission (table 2000000005) or Access Control (table 2000000053) and
    • any table described in Appendix A as “Limited User Included Tables” do not count towards the 3 table objects

APPENDIX A – Limited User Included Tables
The following tables do not count towards the maximum of 3 permitted for Limited Users in Microsoft
Dynamics NAV. Last updated 20 November 2012 (11 tables added)

Table Table NameTableTable Name
43Purch. Comment Line5123Inter. Log Entry Comment Line
44Sales Comment Line5125Purch. Comment Line Archive
51User Time Register5126Sales Comment Line Archive
97Comment Line5150Integration Page
309No. Series Line5151Integration Record
336Tracking Specification5199Attendee
337Reservation Entry5648FA Allocation Dimension
355Dimension Ledger Entry5766Warehouse Activity Header
356Journal Line Dimension5772Registered Whse. Activity Hdr.
357Document Dimension5773Registered Whse. Activity Line
358Production Document Dimension5814Inventory Period
359Posted Document Dimension6550Whse. Item Tracking Line
361G/L Budget Dimension7135Item Budget Dimension
389Service Contract Dimension7310Warehouse Journal Batch
405Change Log Entry7311Warehouse Journal Line
455Approval Line Comment7312Warehouse Entry
480Dimension Set Entry7313Warehouse Register
481Dimension Set Tree Node7318Posted Whse. Receipt Header
952Time Sheet Detail7319Posted Whse. Receipt Line
953Time Sheet Comment Line7320Warehouse Shipment Header
5050Contact7321Warehouse Shipment Line
5051Contact Alt. Address7322Posted Whse. Shipment Header
5052Contact Alt. Addr. Date Range7323Posted Whse. Shipment Line
5054Contact Business Relation7324Whse. Put-away Request
5061Rlshp. Mgt. Comment Line7325Whse. Pick Request
5062Attachment7326Whse. Worksheet Line
5065Interaction Log Entry7331Whse. Internal Put-away Header
5072Campaign Entry7332Whse. Internal Put-away Line
5075Logged Segment7354Bin
5078Segment History2000000067User Default Style Sheet
5080To-do2000000068Record Link
5106Document Dimension Archive2000000073User Personalization
5107Sales Header Archive2000000075User Metadata
5108Sales Line Archive2000000080Page Data Personalization
5109Purchase Header Archive2000000111Session Event
5110Purchase Line Archive

Source: Page 6 and Appendix A in Dynamics ERP Perpetual Licensing Guide.

Leave a comment