ask advice - master data item based on user login

hi there,

need advice.

we want to setup some users, can't access all item nor warehouse.

in simulation, we have 1000 items (1 to 1000), and 2 warehouse (WH_A. WH_ B)

user_A only have access item 1 to 100, and Warehouse WH_A

user_B only have access item 101 to 400, and warehouse WH_B

user_C only have access item 401 to 500, and warehouse WH_A

and other variation.

each user can do GRPO, Delivery, and all transaction for accessible items and warehouse

any experience for this?

thank you.