SQL Injection attack

An SQL injection is a web security vulnerability that allows an attacker to interfere with the queries that an application makes to its database.

It generally allows an attacker to view data that they are not normally able to retrieve. This might include data belonging to other users, or any other data that the application itself is able to access.

In many cases, an attacker can modify or delete this data, causing persistent changes to the application’s content or behaviour.

Mitigations for SQL Injection:

1. Keeping the database updated.

2. Applying least privilege model of permissions in your databases.

3. Using Web Application Firewalls.

4. By not showing error message.

5. Using prepared Statements with variable binding (Parameterized Queries).

6. Whitelisting Input validation.