Bring your software development workflows to security
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.
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 -
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.
No data collected