VDB
EN
CRITICAL 9.9

GHSA-98c2-4cr3-4jc3

n8n has SQL Injection in Data Table Node via orderByColumn Expression

상세

## Impact An authenticated user with permission to create or modify workflows could exploit a SQL injection vulnerability in the Data Table Get node. On default SQLite DB, single statements can be manipulated and the attack surface is practically limited. On PostgreSQL deployments, multi-statement execution is possible, enabling data modification and deletion.

## Patches The issue has been fixed in n8n versions 1.123.26, 2.13.3, and 2.14.1. Users should upgrade to one of these versions or later to remediate the vulnerability.

## Workarounds If upgrading is not immediately possible, administrators should consider the following temporary mitigations: - Limit workflow creation and editing permissions to fully trusted users only. - Disable the Data Table node by adding `n8n-nodes-base.dataTable` to the `NODES_EXCLUDE` environment variable. - Review existing workflows for Data Table Get nodes where `orderByColumn` is set to an expression that incorporates external or user-supplied input.

These workarounds do not fully remediate the risk and should only be used as short-term mitigation measures.

이 버전이 영향받나요?

사용 중인 패키지 버전을 입력하면 즉시 평가합니다.

영향 패키지

npm / n8n
최초 영향 버전: 0 수정 버전: 1.123.26
수정 npm install n8n@1.123.26
npm / n8n
최초 영향 버전: 2.14.0 수정 버전: 2.14.1
수정 npm install n8n@2.14.1
npm / n8n
최초 영향 버전: 2.0.0-rc.0 수정 버전: 2.13.3
수정 npm install n8n@2.13.3

참고