28. End-to-End Project: Blinkit Quick-Commerce Dashboard
28.7 Step 6 – Security
- Create role
City ManageronDarkStorewith[Manager Email] = USERPRINCIPALNAME(). - Test using Modeling › View as › Other user with
shraddha.bagale@example.com(should see only Nashik),ravindra.bagale@example.com(only Pune) andravina@example.com(Pune and Solapur, if you also build the security-table version).
Ravindra Bagale's Tip
Project madhli ek common chuk mhanje adding RLS at the khup end and discovering that the model doesn't support it cleanly. Plan the security table and relationships when you design the model, and test with View as before you publish. Punha ekda karun bagha, mag pudhe jaa.