How to multiple access control for 1 item
Is there any method of multiple access control for 1 item? ex.
|Supplier List (with selective access)|
|Plant List (with selective access)|
|Item1||Plant X||Supplier A|
|Item2||Plant X||Supplier B|
|Item3||Plant Y||Supplier A|
|Item4||Plant Y||Supplier B|
|Plant Write||Supplier Write|
|User 1||All Plant||Supplier A|
|User 2||Plant X||All Supplier|
User 1 is allowed to access item 1 and Item 3 User 2 is allowed to access item 2 and Item 4 I can do single access control by setting hierarchy list ex. plant -Item but hierarchy can apply only one list so i cannot apply supplier list. i do not want to apply item, supplier, plant at the same time to same module.(cause to huge sparsity) i want to control this by selective access or filter function or something. is there any solution?