I try to implement role for user that he/she could process sales orders by giving them all roles that concern sales order processing. Althought roles include all permission for table 246 Requisition line, I receive message "You do not have permission to read table Requisition line".
After giving roles and permission, I have run "synchronize all login" and even test if I grant select on Sql Server table, but no effect. Also I created role for codeunit 5790, but that is maybe not the way to handle it.
Could it be some granule issue? This table 246 have some line data.
Enviroment is: Nav SP1/Sql Server 2000
Error occur in codeunit 5790, function:
CalcScheduledReceipt(VAR Item : Record Item) : Decimal
SELECT SUM("Quantity (Base)") FROM "Company Name$Requisition Line"
WHERE (("Type"=?)) AND (("No_"=?)) AND (("Variant Code"=?)) AND (("Location Code"=?))
AND (("Planning Line Origin"=?)) AND (("Due Date">=? AND "Due Date"<=?))