Forum Discussion
Row level security using if-clause
Hello, I am trying to implement a RLS to limit the security. We are receiving the values to restrict on from a database directly, so in theory I only need to apply a simple RLS where I restrict o...
Hi Dale,
the field generally has restrictions, but for some users it doesn't. Hence I need to make it somehow dynamic, that in case the current user has restrictions, the rule has to be applied, and in case the current user does not have any restrictions (value: *), the rule should not be applied.
Do you see any way how that could be achieved? With an if-clause, or maybe the USERELATIONSHIP() function?
Thanks again,
Chris
Hi Chris,
We can achieve this by assigning roles to the users. If a user have a role, the access of the user will be restricted accoring to the role. Please refer to /service-admin-rls#manage-security-on-your-model and give it a try.
Best Regards,
Dale