Re: Can't get policy to work correctly

2018-03-27 Thread Ivo Limmen
Well I seems I got it working. Still not sure what I did wrong. I finally got it working by moving the sub select into a view and only use the view in the policy: (u): ((hs_group_id IS NULL) OR (hs_group_id IN ( SELECT allowed_hs_groups.hs_group_id FROM allowed_hs_groups))) The allowed_hs

Can't get policy to work correctly

2018-03-27 Thread Ivo Limmen
Hi list! I am a long postgres user but only since a short time I am using the more advanced stuff. And now I use the row level security I run into a problem. I use postgres 9.5.12. I have multiple users; postgres, root and ivo. I have a table called person. It contains multiple rows that should b