Hallo all,
I have the following question:
Currently, I have a number of datasets that I share with our customers. These datasets include data from all customers and to prevent them to view others’ data I use RLS. I attach the RLS file below (namespace etc. are random). You can see that I have multiple namespaces. Each namespace corresponds to a unique customer and some namespaces might have multiple users. Finally, each namespace corresponds to a unique operatorid value, the column that is included in the shared datasets.
Now, a customer request is to allow the users of a namespace to view the data of other namespaces besides their own. That’s because there might be 4 different companies and namespaces, but one is the parent company and the other 3 are the child companies. Then the parent must be enabled to view data from all 4 companies while the 3 child companies must only view their own data. That means that the parent company must have access to multiple values of operatorids.
How can I achieve that?