Security Hub

Bring your software development workflows to security

Oracle Database Logo

Oracle database injection

Signals & Triggers

On Oracle database access
If user input alters SQL query structure

Actions

  • prevent DB driver query execution Prevent db driver query execution
  • block incoming http request Block incoming http request
  • Send a slack notification Send a Slack notification
  • Send an email notification Send an email notification
  • POST to webhook
  • Log request stack trace

Details

A SQL injection happens when a SQL query relies on non-sanitized user inputs. An attacker can then alter the structure of the query in order to return more data than initially expected.

Let’s take a simple example: SELECT first_name, last_name, address, phone_number FROM users where id = '$user_id'. Assuming $user_id comes from the requesting user (HTTP request). Sending a value like ' OR 1 = 1 will result in: SELECT first_name, last_name, address, phone_number FROM users where id ='' OR 1=1. OR 1 = 1 being always true. The attacker just managed to dump the entire user database in a single request.

This plugin detects and blocks HTTP requests triggering SQL injections. This is done without false positives by acting inside the application.

Advanced details

When the application starts, Sqreen library hooks the main DB drivers methods in order to catch queries about to be executed.

Next, on every database request, Sqreen parses the SQL query, just before it is executed. It checks for non-sanitized operators - OR, AND, UNION, … - coming from the user inputs, altering the original query structure and enabling an attacker to derive its original purpose.

No traffic redirection is performed. The analysis of the query happens inside the application, relying on Sqreen’s dynamic instrumentation of the DB driver.

By being in-app and running just before the query is sent to the database server - the very last step in your app - we can guarantee a 100% non false positive detection and protection for injections in Oracle Database.

Language support

  • Node.js
  • PHP
  • Ruby
  • Python
  • Java

Data collected by Sqreen

No data collected


On attack
  • SQL query
  • Request payload
  • Attacker IP
  • Attacker account (Sqreen SDK)
  • Stack trace

Build amazing products. Keep them safe.

Dive into Sqreen with our 14-day trial, and experience seamlessly security. Sign up Request demo