Hi Kappa
You need to activate RLS in both tables for it to work.
I went through the same issues when I tried working with roles: