26.1 What is RLS?
Row-Level Security restricts which rows of data a user can see, using one report for everyone. In our quick-commerce model: the Pune city manager (Ravindra Bagale) should see only the Pune dark stores (Kothrud, Baner, Hadapsar, Hinjewadi, Wakad) and their orders; the Nashik manager (Shraddha Bagale) only Nashik; the Maharashtra state operations head (Rani) sees everything. Without RLS you would have to build and maintain separate reports per city.
RLS works through roles. Each role contains DAX filter expressions on tables. The filter propagates through relationships (संबंध) – so filtering DarkStore automatically filters Orders.
Ravindra Bagale's Tip
Friends, many students think hiding a page or visual is security. It isn't: anyone with build access can see the data. Use RLS to restrict rows, and OLS (Object-Level Security) when whole columns or tables must be hidden. Clear?
Ravindra Bagale's Tip – मराठी
मित्रांनो, बऱ्याच students ना वाटतं page किंवा visual hide करणं म्हणजे security. तसं नाही: build access असलेला कोणीही data बघू शकतो. Rows मर्यादित करण्यासाठी RLS वापरा, आणि संपूर्ण columns किंवा tables लपवायच्या असतील तर OLS (Object-Level Security). समजलं का?
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students सोचते हैं कि page या visual hide करना security है. ऐसा नहीं है: build access वाला कोई भी data देख सकता है. Rows सीमित करने के लिए RLS इस्तेमाल करो, और पूरे columns या tables छिपाने हों तो OLS (Object-Level Security). समझ आया?