Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Find the tables and fields with AccessByPermission
engsiong75
Member Posts: 143
Hi
I am rolling a customer on NAV 2015. There is a new feature called AccessByPermission in the object Table in the Field. If you set it up correctly, you can prevent a user from seeing a field if the user does not have permission to another table.
I found about this feature when a manager started complaining that some of his users could not see the Requested Receipt Date in the Purchase Order page. It turned that the users who could not see the Requested Receipt Date did not have permission to a table called Order Promising Line. As there was an AccessByPermission setting on the Purchase Header Table to the field Requested Receipt Date, the users could not see the field in the Purchase Order Page.
Fixing the issue by giving the user permission to the Order Promising table is not an issue.
However, to prevent another surprise by this feature, I tried to locate which tables and fields have this setting in standard NAV. There are 750+ fields in various tables with this issue. This going to take time for me to locate all the fields and the related table.
Does anyone have a table of all the tables and fields that have the AccessByPermission? Alternatively, does anyone have an idea if there is a better to get the information than exporting all the tables to a text file and filtering the data?
Thanks
I am rolling a customer on NAV 2015. There is a new feature called AccessByPermission in the object Table in the Field. If you set it up correctly, you can prevent a user from seeing a field if the user does not have permission to another table.
I found about this feature when a manager started complaining that some of his users could not see the Requested Receipt Date in the Purchase Order page. It turned that the users who could not see the Requested Receipt Date did not have permission to a table called Order Promising Line. As there was an AccessByPermission setting on the Purchase Header Table to the field Requested Receipt Date, the users could not see the field in the Purchase Order Page.
Fixing the issue by giving the user permission to the Order Promising table is not an issue.
However, to prevent another surprise by this feature, I tried to locate which tables and fields have this setting in standard NAV. There are 750+ fields in various tables with this issue. This going to take time for me to locate all the fields and the related table.
Does anyone have a table of all the tables and fields that have the AccessByPermission? Alternatively, does anyone have an idea if there is a better to get the information than exporting all the tables to a text file and filtering the data?
Thanks
0
Comments
Apparently there is a setting in the 2015 Administration called UI Elements Removal. It was set to LicenseFileandUserPermission. I am setting it to License File to see if the issue is resolved.
Thank you,