Forum Discussion
Optimizing RLS Access: Unifying Country, organization and Legal Access in a Multi-Level Structure
Hi mejaybird
Based on your description, I have some questions. Does all data have corresponding Organization, Legal and Country information? Like [email protected], he doesn't have any organization and country information in your RLS table, does this mean that he can have access to data related to Pacific scientific and electronic corporation in all organizations and countries? Like [email protected], does he have access to data related to electronic corporation in all countries or only in United States, or data in other scopes?
Besides, I found a blog that looks similar to your scenario. You may read it through the following link first to check whether it can be applied to your report.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
The email address [email protected] is granted access to information concerning the electronic corporation across all countries, as well as all data specifically related to the United States.
The email address [email protected] is authorized to access information pertaining to Legal Pacific Scientific matters across all organizations and countries.
