Forum Discussion
Hussein_charif
Helper V
Helper Vtables relation issue
i have this db model : for the customers table, the salesteam column is a calculated column taken from the salesteam table by using lookup(). i have made a rls rule with the userprincipalname(...
mh2587
Super User
Super UserIf removing the calculated column is not feasible, consider introducing a bridge table for SalesTeam to manage the RLS filtering:
- Create a bridge table that only holds SalesTeam values and connects Customer and SalesPerson.
- Establish relationships from both Customer and SalesPerson to the bridge table instead of directly linking Customer to SalesTeam.
- Apply your RLS on the bridge table to enforce filtering based on SalesTeam values.
Hussein_charifHelper V
Helper Vi got an error ambiguous paths, because sales is connected to customer and customer is connected to the bridge table, and sales is also connected to salesperson and salesperson is connected to the bridge table