user table has user details
role table has role details (ex: admin, manager, supervisor)
permission table has permission details (ex: sales_order, purchase_order)
access table has 3 rows - read, update, write
role association table has role_id, per_id, access_id
role child association 1 has user_id, role_id
role child association 2 has user_id, role_id, country_id
currently the access is based on role level….
how to design the DB to access specific level instead of role level.