Description
ZR.Admin.NET through 3.8.2 contains an sql injection vulnerability that allows authenticated attackers to manipulate the ORDER BY clause by supplying a crafted PagerInfo.Sort query parameter to the shared ToPage paging helper. Attackers holding the system:user:list permission can inject subquery or CASE expressions via GET /system/user/list to extract database contents such as stored credentials through blind techniques.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| izhaorui | Zr.Admin.NET | ≤ 3.8.2 | — |
References
- https://hackmd.io/@hieuPenguinnn/zradmin-net-order-by-sort-sql-injection third-party-advisory
- https://github.com/izhaorui/Zr.Admin.NET/blob/v3.8.1/ZR.Repository/BaseRepository.cs#L342-L351 technical-description
- https://github.com/izhaorui/Zr.Admin.NET/blob/v3.8.1/ZR.Admin.WebApi/Controllers/System/SysUserController.cs#L47-L52 technical-description
- https://github.com/izhaorui/Zr.Admin.NET/commit/d32c211aeedab3e07bb4f02f54bb251fff37361c patch
- https://gitee.com/izory/ZrAdminNetCore/tags product
- VulnCheck Advisory: ZR.Admin.NET through 3.8.2 SQL Injection via PagerInfo.Sort ORDER BY third-party-advisory