I have created an app with a set of different tables like:
Following User roles are defined for now:
For these four Roles not security filter shall be applied on all tables of the app:
For all others one Security filter shall be applied like the following:
[FirmenID] = LOOKUP(USEREMAIL(), “Nutzer”, “E-Mail”, “FirmenID”)
On all tables I have included the REF column [FirmenID]. This is nevertheless only maintained for the security relevant Roles on User table.
How can i make this SF conditional?
How can multiple Roles best be assigned IF a more detailed separation of functions is needed?
Thanks so much for any help.