Oracle Security: SQL Injection

From Robs_Wiki
Revision as of 08:49, 28 January 2020 by Qadmin wiki (talk | contribs) (How does SQL Injection take place?)
Jump to: navigation, search

What is SQL Injection ?

SQL injection is a technique to maliciously exploit applications that use client-supplied data in SQL statements. Attackers trick the SQL engine into executing unintended commands by supplying specially crafted string input, thereby gaining unauthorized access to a database in order to view or manipulate restricted data.

How does SQL Injection take place?

Incorrectly validated or nonvalidated string literals are concatenated into a dynamic SQL statement, and interpreted as code by the SQL engine. The code passage below is an example of code that is vulnarable for SQL Injection:

'select email from employees 
where email = '''|| p_email|| ''' 
and last_name = ''' ||p_last_name || '''';