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 Name Table Table Name
43 Purch. Comment Line 5123 Inter. Log Entry Comment Line
44 Sales Comment Line 5125 Purch. Comment Line Archive
51 User Time Register 5126 Sales Comment Line Archive
97 Comment Line 5150 Integration Page
309 No. Series Line 5151 Integration Record
336 Tracking Specification 5199 Attendee
337 Reservation Entry 5648 FA Allocation Dimension
355 Dimension Ledger Entry 5766 Warehouse Activity Header
356 Journal Line Dimension 5772 Registered Whse. Activity Hdr.
357 Document Dimension 5773 Registered Whse. Activity Line
358 Production Document Dimension 5814 Inventory Period
359 Posted Document Dimension 6550 Whse. Item Tracking Line
361 G/L Budget Dimension 7135 Item Budget Dimension
389 Service Contract Dimension 7310 Warehouse Journal Batch
405 Change Log Entry 7311 Warehouse Journal Line
455 Approval Line Comment 7312 Warehouse Entry
480 Dimension Set Entry 7313 Warehouse Register
481 Dimension Set Tree Node 7318 Posted Whse. Receipt Header
952 Time Sheet Detail 7319 Posted Whse. Receipt Line
953 Time Sheet Comment Line 7320 Warehouse Shipment Header
5050 Contact 7321 Warehouse Shipment Line
5051 Contact Alt. Address 7322 Posted Whse. Shipment Header
5052 Contact Alt. Addr. Date Range 7323 Posted Whse. Shipment Line
5054 Contact Business Relation 7324 Whse. Put-away Request
5061 Rlshp. Mgt. Comment Line 7325 Whse. Pick Request
5062 Attachment 7326 Whse. Worksheet Line
5065 Interaction Log Entry 7331 Whse. Internal Put-away Header
5072 Campaign Entry 7332 Whse. Internal Put-away Line
5075 Logged Segment 7354 Bin
5078 Segment History 2000000067 User Default Style Sheet
5080 To-do 2000000068 Record Link
5106 Document Dimension Archive 2000000073 User Personalization
5107 Sales Header Archive 2000000075 User Metadata
5108 Sales Line Archive 2000000080 Page Data Personalization
5109 Purchase Header Archive 2000000111 Session Event
5110 Purchase Line Archive

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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s