We would like to have some dev users without data security too see all available data without assigning service admin to them.
As of now, the options are:
- Remove the mapping of data security roles, we would prefer not to go this way to preserve the default mapping
- Create custom data security with 1=1 as condition to override custom roles, however this would require a role for each functional group filter. This step is high effort and we dont even have a document with the existing functional groups.
What would be the best way to achieve this?
How is servic admin able to bypass all data roles? I was hoping there is a way to have this mechanism only , without granting the rest of service admin permissions.