Permission check
The three-join path from a membership to a permission.
select 1
from memberships m
join membership_roles mr on mr.membership_id = m.id
join role_permissions rp on rp.role_id = mr.role_id
join permissions p on p.id = rp.permission_id
where m.user_id = '00000000-0000-0000-0000-000000000001'::uuid
and m.organization_id = '00000000-0000-0000-0000-000000000002'::uuid
and p.resource = 'articles'
and p.action = 'delete';