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
A common project mistake is adding RLS at the very 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. Try it once more, then move on.
Ravindra Bagale's Tip – मराठी
Project मधली एक common चूक म्हणजे अगदी शेवटी RLS जोडणं आणि मग model ला ते नीट support करत नाही हे लक्षात येणं. Model design करतानाच security table आणि relationships चं planning करा, आणि publish करण्याआधी View as ने test करा. पुन्हा एकदा करून बघा, मग पुढे जा.
Ravindra Bagale's Tip – हिंदी
Project की एक common गलती है बिल्कुल आख़िर में RLS जोड़ना और फिर पता चलना कि model उसे ठीक से support नहीं करता. Model design करते समय ही security table और relationships की planning करो, और publish करने से पहले View as से test करो. एक बार फिर करके देखो, फिर आगे बढ़ो.