Understanding Injection Attacks

In today's digital world, web applications are often targeted by attackers using various methods to compromise sensitive data and systems. One of the most prevalent and dangerous categories of attacks is injection attacks. In this article, we will delve into the world of injection attacks, exploring their types and providing real-world examples to help readers understand the severity of these vulnerabilities.

Types of Injection Attacks:

1. SQL Injection (SQLi):

  SQL injection is a commonly exploited vulnerability where an attacker can insert malicious SQL statements into input fields to gain unauthorized access to a website's database. For example, an attacker may use SQL injection to extract sensitive information such as usernames, passwords, and financial data from a vulnerable website.

2. Cross-site Scripting (XSS):

  Cross-site scripting allows attackers to inject malicious scripts into web pages viewed by other users. This can lead to various attacks, such as account impersonation, defacement of web pages, and executing arbitrary JavaScript in victims' browsers.

3. Code Injection:

  In a code injection attack, an attacker injects application code, often written in the application language, to execute operating system commands with the user's privileges. This can lead to full system compromise if additional privilege escalation vulnerabilities are exploited.

4. CRLF Injection:

  A CRLF (Carriage Return and Line Feed) injection occurs when an attacker injects unexpected character sequences to split an HTTP response header and write arbitrary content to the response body. This can be used in conjunction with Cross-site Scripting attacks.

5. Email Header Injection:

   This attack is similar to CRLF injections but involves sending IMAP/SMTP commands to a mail server not directly available via a web application. The consequences may include spam relay and information disclosure.

6. Host Header Injection:

   Attackers abuse the implicit trust of the HTTP Host header to poison password-reset functionality and web caches, leading to password-reset poisoning and cache poisoning.

7. LDAP Injection:

  LDAP injection involves injecting LDAP statements to execute arbitrary commands, gain permissions, and modify the contents of the LDAP tree. This can result in authentication bypass, privilege escalation, and information disclosure.

8. OS Command Injection:

OS command injection allows attackers to inject operating system commands with the user's privileges, potentially leading to full system compromise if additional vulnerabilities are leveraged.

9. XPath Injection:

  Attackers inject crafted XPath queries into an application to access unauthorized data and bypass authentication. The consequences may include information disclosure and authentication bypass.

Conclusion:

Injection attacks pose a significant threat to web applications and the sensitive data they process. It is crucial for organizations and developers to understand the various types of injection attacks and implement robust security measures to mitigate these vulnerabilities. By staying informed and adopting secure coding practices, businesses can effectively safeguard their web applications against these pervasive and potentially devastating threats. 

What is a SQL Injection Attack?

SQL injection is a type of web application security vulnerability and attack that occurs when an attacker is able to manipulate an application's SQL (Structured Query Language) statements. It takes advantage of poor input validation or improper construction of SQL queries, allowing the attacker to insert malicious SQL code into the application's database query.

SQL Injection attacks are also called SQLi. SQL stands for 'structured query language' and SQL injection is sometimes abbreviated to SQLi

Impact of SQL injection on your applications

Steal credentials—attackers can obtain credentials via SQLi and then impersonate users and use their privileges.

Access databases—attackers can gain access to the sensitive data in database servers.

Alter data—attackers can alter or add new data to the accessed database. 

Delete data—attackers can delete database records or drop entire tables. 

Lateral movement—attackers can access database servers with operating system privileges, and use these permissions to access other sensitive systems.

Types of SQL Injection Attacks

There are several types of SQL injection:

Union-based SQL Injection – Union-based SQL Injection represents the most popular type of SQL injection and uses the UNION statement. The UNION statement represents the combination of two select statements to retrieve data from the database.

Error-Based SQL Injection – this method can only be run against MS-SQL Servers. In this attack, the malicious user causes an application to show an error. Usually, you ask the database a question and it returns an error message which also contains the data they asked for.

Blind SQL Injection – in this attack, no error messages are received from the database; We extract the data by submitting queries to the database. Blind SQL injections can be divided into boolean-based SQL Injection and time-based SQL Injection.

SQLi attacks can also be classified by the method they use to inject data:

SQL injection based on user input – web applications accept inputs through forms, which pass a user’s input to the database for processing. If the web application accepts these inputs without sanitizing them, an attacker can inject malicious SQL statements.

SQL injection based on cookies – another approach to SQL injection is modifying cookies to “poison” database queries. Web applications often load cookies and use their data as part of database operations. A malicious user, or malware deployed on a user’s device, could modify cookies, to inject SQL in an unexpected way.

SQL injection based on HTTP headers – server variables such HTTP headers can also be used for SQL injection. If a web application accepts inputs from HTTP headers, fake headers containing arbitrary SQL can inject code into the database.

Second-order SQL injection – these are possibly the most complex SQL injection attacks, because they may lie dormant for a long period of time. A second-order SQL injection attack delivers poisoned data, which might be considered benign in one context, but is malicious in another context. Even if developers sanitize all application inputs, they could still be vulnerable to this type of attack.

Here are few defense mechanisms to avoid these attacks 

1. Prepared statements:  These are easy to learn and use, and eliminate problem  of SQL Injection. They force you to define SQL code, and pass each parameter to the query later, making a strong distinction between code and data

2. Stored Procedures: Stored procedures are similar to prepared statements, only the SQL code for the stored procedure is defined and stored in the database, rather than in the user’s code. In most cases, stored procedures can be as secure as prepared statements, so you can decide which one fits better with your development processes.

There are two cases in which stored procedures are not secure:

The stored procedure includes dynamic SQL generation – this is typically not done in stored procedures, but it can be done, so you must avoid it when creating stored procedures. Otherwise, ensure you validate all inputs.

Database owner privileges – in some database setups, the administrator grants database owner permissions to enable stored procedures to run. This means that if an attacker breaches the server, they have full rights to the database. Avoid this by creating a custom role that allows storage procedures only the level of access they need.

3. Allow-list Input Validation: This is another strong measure that can defend against SQL injection. The idea of allow-list validation is that user inputs are validated against a closed list of known legal values.

4. Escaping All User-Supplied Input: Escaping means to add an escape character that instructs the code to ignore certain control characters, evaluating them as text and not as code.