Row Level Security for different group of users
I did not find any relevant data for my below question what i want to check, I have explained the scenario below.
I have a sales data set which has different Groups and Sub - Group and i wanted to know how can i achieve the security for same.
1. I have Geography wise Group say Inida, Australia, Singapore and US
2. In each of the above group i have Sub Group say Sales Director which should be able to see all the Sales Report at the Global Region Level say for Example All the countries mentioned above.
Again we have another sub-group say Sales Regional Manager which should see specific to region and another sales group say AE.
How do we configure the security for such kind of scenarios.