DROP POLICY IF EXISTS crm_rbac_insert ON public.crm;
CREATE POLICY crm_rbac_insert ON public.crm
FOR INSERT
TO authenticated
WITH CHECK (
public.rbac_organization_has_permission(
(SELECT auth.uid()),
NEW.organisation_id,
'crm_create'
)
);
DROP POLICY IF EXISTS crm_rbac_insert ON public.crm;
CREATE POLICY crm_rbac_insert ON public.crm
FOR INSERT
TO authenticated
WITH CHECK (
public.rbac_organization_has_permission(
(SELECT auth.uid()),
NEW.organisation_id,
'crm_create'
)
);