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
- 302 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
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