I have requirement to show the report data only users for specific regions. For example, i have 2 regions and we have users in each region. If user from region 1 seeing the report then he should see only his region related information.
I have done this using row level security in universe level using BO user. But the issue is, we used to add new users frequently. If this is the case then i need to hard code the user name (BO user) every time in universe.
This is not possible. Is there any possibility to apply the security to groups without hard code users because if new user means we can add it in to the groups.
We are not storing the user names in separate table, user names can see only in groups.