cazzer · August 2, 2018 05:25
diff --git a/rls-performance-view-view.sql b/rls-performance-view-view.sql
 create view items_view
 with (security_barrier)
 as
  select items.*
  from items
  join permissions on item_id = items.id
  and user_or_group_id =
    any(regexp_split_to_array(current_setting('jwt.claims.roles'), ',')::uuid[]);
	create view items_view
	with (security_barrier)
	as
	select items.*
	from items
	join permissions on item_id = items.id
	and user_or_group_id =
	any(regexp_split_to_array(current_setting('jwt.claims.roles'), ',')::uuid[]);