A Review of SQL Injection Attacks: Detection Methods, Vulnerability Examples, and Prevention and Mitigation Strategies

A Review of SQL Injection Attacks: Detection Methods, Vulnerability Examples, and Prevention and Mitigation Strategies

Hadi Norouzi1 Alireza Mashhadizadeh2

1) Associate Degree Student in Computer Engineering, Shahr-e Kord Boys Campus, National University of Skills, Chaharmahal and Bakhtiari, Iran
2) Associate Degree Student in Computer Engineering, Shahr-e Kord Boys Campus, National University of Skills, Chaharmahal and Bakhtiari, Iran

IOI Code : AAHD-ACACCG
Publication : National Conference on Information Technology, Nanotechnology, Artificial Intelligence and Technological Futures Studies(itnaf.ir)
Abstract :
    With the growing use of the Internet, websites, and various software applications, the security of information and databases has become increasingly important. One of the most significant security threats in this area is SQL Injection. This attack occurs when user inputs are not properly validated, allowing an attacker to execute unauthorized SQL commands through those inputs. As a result, sensitive information may be disclosed, modified, or deleted. The aim of this paper is to introduce the concept and mechanism of SQL Injection attacks, examine methods for identifying vulnerabilities, present examples of vulnerable points in applications, and provide prevention and mitigation strategies. This paper explains how such vulnerabilities arise in simple terms and discusses solutions such as parameterized queries, user input validation, restricting database access privileges, proper error message handling, software updates, and regular security testing. The findings indicate that awareness of this type of attack and adherence to security principles in software design and implementation can significantly reduce the likelihood of vulnerabilities and contribute to better protection of users information.

Keywords : database security vulnerability sql commands parameterized queries attack prevention