Use parameterized queries
Summary
The system must use parameterized queries or stored procedures to create dynamic sentences (e.g., java.sql.PreparedStatement).
Description
One of the main reasons for using parameterized queries or stored procedures is to prevent SQL injection attacks. When applications concatenate user input directly into SQL statements, attackers may inject malicious SQL code, potentially leading to unauthorized access or data manipulation. Parameterized queries ensure that user input is treated as data, not as executable code, mitigating the risk of SQL injection.
Supported In
This requirement is verified in following services
| Plan | Supported |
|---|---|
| Essential | 🔴 |
| Advanced | 🔴 |
References
- CAPEC™-7. Blind SQL injection
- CAPEC™-248. Command injection
- CWE™-89. Improper neutralization of special elements used in an SQL command ("SQL injection")
- CWE™-130. Buffer copy without checking size of input ("classic buffer overflow")
- CWE™-598. Use of GET request method with sensitive query strings
- OWASP TOP 10-A3. Injection
- Agile Alliance-9. Continuous attention to technical excellence and good design
- BIZEC-APP-APP-02. OS command injection
- BIZEC-APP-APP-06. Direct database modifications
- BIZEC-APP-APP-08. Open SQL injection
- CERT-J-IDS00-J. Prevent SQL injection
- MITRE ATT&CK®-M1013. Application developer guidance
- PA-DSS-5_2_1. Injection flaws, particularly SQL injection
- SANS 25-3. Improper neutralization of special elements used in an SQL command (SQL injection)
- WASSEC-5_5. Extraction of dynamic content
- WASSEC-6_2_4_4. Command execution - SQL injection
- WASC-A_19. SQL injection
- WASC-W_20. Improper input handling
- ISSAF-T_6_6. Web application assessment - Identifying web server vendor and version (by error)
- ISSAF-T_17. Web application assessment - Test SQL injection
- ISSAF-U_15. Web application SQL injections – Countermeasures
- PTES-5_2_3_1. Vulnerability analysis - Web application scanners (application flaw scanners)
- PTES-7_4_2_3. Post exploitation - Pillaging (database servers)
- OWASP SCP-11. Database security
- CWE TOP 25-89. Improper neutralization of special elements used in an SQL command (SQL injection)
- OWASP ASVS-5_3_4. Output encoding and injection prevention
- PCI DSS-6_2_4. Software engineering techniques to prevent or mitigate common software attacks
- OWASP ASVS-5_3_5. Output encoding and injection prevention
- CASA-5_3_4. Output Encoding and Injection Prevention
- OWASP MASVS-CODE-4. The app validates and sanitizes all untrusted inputs
Vulnerabilities
- 001. SQL injection - C Sharp SQL API
- 012. SQL injection - Java Persistence API
- 105. Apache lucene query injection
- 106. NoSQL injection
- 112. SQL injection - Java SQL API
- 146. SQL injection
- 154. Time-based SQL Injection
- 155. SQL Injection - Headers
- 297. SQL injection - Code
- 438. Error-based SQL Injection
Search for vulnerabilities in your apps for free with Fluid Attacks' automated security testing! Start your 21-day free trial and discover the benefits of the Continuous Hacking Essential plan. If you prefer the Advanced plan, which includes the expertise of Fluid Attacks' hacking team, fill out this contact form.