Forum Discussion
Arpit_Jain
3 years agoFrequent Visitor
ROW LEVEL SECURITY filtering across two table context
Hi All, I’m a beginner at RLS. I’ve several tables out of which two table are of priority for this discussion. I’m providing you a sample for the same- Period Table: Period Type. Period Value. monthly. Jan’22 Monthly. Feb’22 Monthly. Apr’21 Quarterly. JFM’22 Quarterly. AMJ’22 Quarterly. AMJ’21 Sales table: Period. Category. Sales units. Jan’22. Heater. 1000 Feb’22. Fans. 5000 Feb’22. Heaters. 100 Apr’21. Fans. 2000 Apr’21. Heaters. 1100 Jan’22. Purifiers. 500 I would like RLS in such a way that user is able to see the Fans data only for quarterly period while both monthly and quarterly data is available for heaters and in the process completely leaving out purifiers. A quick help is much needed. Regards
1 Reply
- miTutorialsSuper UserWatch this video to understand how to setup the RLS. https://www.youtube.com/watch?v=EB9384RwnXw