########################################################################
####
Red-Database-Security GmbH  - Oracle Reports Security Advisory

Generic SQL Injection Vulnerability in Oracle Reports via Lexical
References

 Name                Generic SQL Injection Vulnerability in Oracle
Reports 
                     via Lexical References
 Systems Affected    Generated Oracle Reports using Lexical References
 Severity            High Risk 
 Category            SQL Injection
 Remote Exploitable  Yes
 Vendor URL          https://www.oracle.com 
 Author              Alexander Kornbrust (ak at
red-database-security.com) 
 Date                15 September 2005 (V 1.00) 
 Advisory-URL        
 https://www.red-database-security.com/wp/sql_injection_reports_us.pdf

 

Details
#######
Oracle Reports provides a feature called lexical references. A lexical 
reference is a placeholder for text that you embed in a SELECT
statement. 
It is possible to replace the clauses appearing after SELECT, FROM,
WHERE, 
GROUP BY, ORDER BY, HAVING, CONNECT BY and START WITH.

If lexical references are in use it is possible to modify SQL statements
via a simple URL. After adding the parameter "paramform=yes" in the URL
a parameter form window appears (=SQL Injection with a menu). 

An attacker can modify the parameter values and inject SQL statements.



Testcase
########
Executed an Oracle Report via an URL, e.g.
https://myserver:8889/reports/rwservlet?report=sqlinject3.rdf+userid=scot
t/tiger@ora9206+destype=CACHE+desformat=HTML 

Add the value paramform=yes to the URL
https://myserver:8889/reports/rwservlet?report=sqlinject3.rdf+userid=scot
t/tiger@ora9206+destype=CACHE+desformat=HTML+paramform=yes 

A parameter window appears. Inject the SQL statement by modifying the
values
in the parameter form and submit the query.


A detailed description including hardcopies is available in the PDF
advisory:

https://www.red-database-security.com/wp/sql_injection_reports_us.pdf
(English)
https://www.red-database-security.com/wp/sql_injection_reports_dt.pdf
(German)



Affected systems
################
All generated reports using lexical references without input validation.



Patch Information
#################
This issue is not a bug in Oracle Reports itself. It is a problem of
missing input validation in all generated Oracle Reports.



Fix
###
Validate all parameter values before the SQL statement is executed in an

After-Parameter-Form-Trigger.



History
#######
14-may-2004 Oracle secalert was informed to give them time to fix their
reports in the E-Business Suite.

15-sep-2005 Red-Database-Security published this advisory



(c) 2005 by Red-Database-Security GmbH
https://www.red-database-security.com