Cacher is the code snippet organizer for pro developers

-- permission details
select
  concat(case when os.org_id is not null then os.org_id else '*' end, case when os.wildcard = 1 then '+' else '' end)  as 'org_spec',
  re.path_expr,
  pb.permission_name as 'permission',
  coalesce(tag.tag, '', ',') as 'tags'
from
  authz_permission_binding pb
join authz_resource_expression re on re.id = pb.resource_expression_id
join authz_org_spec os on os.id = re.org_spec_id
left outer join authz_resource_expression_tag tag on tag.resource_expression_id = re.id
order by
  org_spec,
  path_expr;