Unauthenticated database deletion via raw SQL interpolation
Published Feb 27, 2024 · Updated Aug 1, 2024
SQL injection in SourceCodester Simple Student Attendance System 1.0 allows remote attackers to delete database records via crafted id values. The delete_class and delete_student handlers in ajax-api.php interpolate the POST id value directly into DELETE queries without parameterization. No authentication is required, and injected conditions can delete every class or student record available to the application's database account.
Summary
What happened
SQL injection in SourceCodester Simple Student Attendance System 1.0 allows remote attackers to delete database records via crafted id values. The delete_class and delete_student handlers in ajax-api.php interpolate the POST id value directly into DELETE queries without parameterization. No authentication is required, and injected conditions can delete every class or student record available to the application's database account.
The record
- CVE
- CVE-2024-1923
- Published
- Feb 27, 2024
- Updated
- Aug 1, 2024
- Vendor
- Online Computer and Laptop Store Project
- Product
- Simple Student Attendance System
- Classifications
- CWE-89, T1190
- Attack vector
- network
- Privileges
- unauthenticated
Timeline
How it unfolded
- Feb 27, 2024CVE publishedPublication date reported by the CVE source.
- Aug 1, 2024Record updatedLatest update available in the CVE record.
Exploitability
Present is not the same as exploitable
Compare your product and version with the public record. A matching version still requires validation against your environment.
Is a vulnerable build present?
Compare these published version ranges with your installed build and any vendor patches.
- Affected versionversion=1.0
What conditions does exploitation require?
What is affected?
Attacks
What attackers are doing with it
Daily unique IPs observed by Shadowserver honeypots for known exploited vulnerabilities (KEVs). Missing observations do not establish an absence of attacks.
Weakness, pattern, technique
Public exploit references
- Unauthenticated delete_class SQL injection proof of conceptproof of concept · demonstrated
Labels summarize the accepted research assessment. They do not indicate a test against your environment.
Technologies
Your stack
See the directory against your own environment.
Your stack
Check the software in your environment
Book a demo to see how Hinoki identifies affected software and validates exploitability in your environment.
Book a demo