user permissions

leugim

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!

leugim

hi again...

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