Share
Report
4,548I will explain proplem from first I have two useres A B AND two itemes sp,wa I need to assign role to user A to see item sp but not see wa(spare) I need to assign role to user B to see item wa but not see sp(water) if i make purchase order have sp item this is last record i added and his item category sp then user A can see order i make because last record added sp so user A Can open purchase order form and browsing orderes But proplem happen when user B open purchase order form . the purchase order form not open and give him error "you dont have permission to read item table" because last record have sp item category code. how i solve this proplem user A have two roles ALL spare ALL(have as following) all table data one by one(without item table) read insert modify execute tabel 0 yes yes yes yes form 0 yes yes yes yes report 0 yes yes yes yes spare role (have as following) item yes yes yes yes item category code=sp User B Have two roles ALL WATER ALL(as following) all table data one by one(without item table) read insert modify execute tabel 0 yes yes yes yes form 0 yes yes yes yes report 0 yes yes yes yes WATER(have as following) item yes yes yes yes item category code=wa how i solve this proplem(how to avoid last record not much security filter not affect to form of purchase order) i need solve to proplem if possible
*This post is locked for comments
All responses (
Answers (
