I need Help with RLS

[PedroModa]

Good afternoon!

I understand that RLS hides row-level information, however, I have a problem...

In the print below, the person can only see the green accounts, not the red ones. In other words, it cannot view the amount that came out of debit (which is in red), but only the amount that went into credit, however, if I put this rule in the rls (only display the account in green) it hides the entire line, as it contains an account (in red) that cannot be displayed, but I need to display only the credit. How could I solve this problem? This is a fact table, I thought about dividing it into 2, one table would be only for debit accounts and the other only for credit accounts. Today I have measurements that are created considering a single table, could I have a problem with the measurements (due to the fact that they are 2 fact tables and cannot relate to each other)?

Is there any way to "hide" values ​​in the RLS and not the entire line? Because then I would hide the account number in red and only take the account that is in green... Is there any easier way I could solve this?

[lbendlin · Accepted solution]

Using two tables and measures is a sensible approach.

You can read about OLS (Object Level Security)  but that operates on entire columns or tables, so it doesn't fit your scenario.  RLS is still the better choice for you.

[PedroModa]

Thank you!