Skip to content
OpenAdvisories
High GHSA-4mg9-vhxq-vm7j

SQL Server LIMIT / OFFSET SQL Injection in laravel/framework and illuminate/database

Published Apr 29, 2021 · Updated Dec 2, 2024 · Assigned by GHSA

Description

### Impact

Those using SQL Server with Laravel and allowing user input to be passed directly to the `limit` and `offset` functions are vulnerable to SQL injection. Other database drivers such as MySQL and Postgres are not affected by this vulnerability.

### Patches

This problem has been patched on Laravel versions 6.20.26, 7.30.5, and 8.40.0.

### Workarounds

You may workaround this vulnerability by ensuring that only integers are passed to the `limit` and `offset` functions, as well as the `skip` and `take` functions.

Affected packages

EcosystemPackageAffectedFixedRecord
Packagist illuminate/database >= 8.0.0, < 8.40.0 8.40.0 GHSA-4mg9-vhxq-vm7j
Packagist illuminate/database < 6.20.26 6.20.26 GHSA-4mg9-vhxq-vm7j
Packagist laravel/framework >= 8.0.0, < 8.40.0 8.40.0 GHSA-4mg9-vhxq-vm7j
Packagist laravel/framework < 6.20.26 6.20.26 GHSA-4mg9-vhxq-vm7j

References