Forum Discussion
Why add =FALSE() in RLS?
- 4 years ago
Hi Anonymous
I believe RLS requires an expression to return a TRUE/FALSE value, so it would make sense for security that in the absense of an expression to evaluate, it defaults to FALSE preventing someone from accessing the data just because they have no role
Even though you might have left it blank in the past, I guess in the background it's forcing the value to FALSE
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
I believe RLS requires an expression to return a TRUE/FALSE value, so it would make sense for security that in the absense of an expression to evaluate, it defaults to FALSE preventing someone from accessing the data just because they have no role
Even though you might have left it blank in the past, I guess in the background it's forcing the value to FALSE
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.