Column/Field Level Security-NAV2016

KWevick
Member Posts: 103
We need to select certain fields, in various tables, to be unavailable for reporting, but available for posting. Also, the security needs to extend beyond NAV to add-ons and other solutions which access the data. We've done this internally in NAV by programming, but the need has grown. It's a requirement of the CEO and NAV doesn't do that is not an option.
For example, the user needs to be able to post to the G/L, but not view the Ledger Entries. Changing security to Indirect does not work. And the list goes on. We are looking at Row Security and possible adding some fields to the tables impacted to make the solution easier to maintain, but they will still be able to see what they can see.
Any help of suggestions would be helpful.
Thank you
For example, the user needs to be able to post to the G/L, but not view the Ledger Entries. Changing security to Indirect does not work. And the list goes on. We are looking at Row Security and possible adding some fields to the tables impacted to make the solution easier to maintain, but they will still be able to see what they can see.
Any help of suggestions would be helpful.
Thank you
0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions