Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 295 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
user permissions
leugim
Member Posts: 93
hi all
we have an implemented database under SQL with several users. one of them, and only this one, needs to be filtered by his salesperson code. we have created a new role for this user, with some permissions for some TableData filtered by his salesperson code in fact. permissions are set to YES in all columns (read, insert, modify, delete and execute). some tables related in this role are table 18 Customer, 36 Sales Header, 112 Sales Invoice Header and so on... we have syncronized the user connection and everything is ok. then we open a new NAV client, open database with this user.
opening customer card has no problem and only shows customers assigned to the filtered salesperson code . opening sales invoice header has no problem and also only shows records with the filtered salesperson code.
then trying to open a sales quote shows the error: "You have no permission to read Sales Invoice Header table". this error appears courtesy of codeunit 7171, when updating the SalesInfoPane on Sales Quote Lines Subform, performing ISEMPTY function. checking NAV help for ISEMPTY function, filters are used and we think this includes filters applied in permissions... doesn't it?
could someone tell us why we reach this error??
regards in advance, thks for your time!
we have an implemented database under SQL with several users. one of them, and only this one, needs to be filtered by his salesperson code. we have created a new role for this user, with some permissions for some TableData filtered by his salesperson code in fact. permissions are set to YES in all columns (read, insert, modify, delete and execute). some tables related in this role are table 18 Customer, 36 Sales Header, 112 Sales Invoice Header and so on... we have syncronized the user connection and everything is ok. then we open a new NAV client, open database with this user.
opening customer card has no problem and only shows customers assigned to the filtered salesperson code . opening sales invoice header has no problem and also only shows records with the filtered salesperson code.
then trying to open a sales quote shows the error: "You have no permission to read Sales Invoice Header table". this error appears courtesy of codeunit 7171, when updating the SalesInfoPane on Sales Quote Lines Subform, performing ISEMPTY function. checking NAV help for ISEMPTY function, filters are used and we think this includes filters applied in permissions... doesn't it?
could someone tell us why we reach this error??
regards in advance, thks for your time!
_______________
so far, so good
so far, so good
0
Answers
we have found the solution. when you preconfigure permissions filtered by some fields, the C/AL code isn't able to "read" those permissions, you have to code it explicitly with SETPERMISSIONSFILTER instruction.
hope this will be helpful
regards to you all
so far, so good