[Full-disclosure] Team SHATTER Security Advisory: SQL Injection in Oracle Database CREATE_CHANGE_SET procedure

[Shatter <shatter@xxxxxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Team SHATTER Security Advisory

SQL Injection in Oracle Database CREATE_CHANGE_SET procedure

Oct. 13 2010

Affected versions:
Oracle Database Server version 10gR1, 10gR2, 11gR1 and 11gR2

Remote exploitable:
Yes (Authentication to Database Server is needed)

Credits:
This vulnerability was discovered and researched by Esteban Martínez Fayó of 
Application Security Inc.

Details:
Oracle Database provides the DBMS_CDC_PUBLISH PL/SQL package owned by SYS that 
is part of the Change Data Capture component. This package has a SQL Injection 
vulnerability in CREATE_CHANGE_SET procedure. A malicious user can call the 
vulnerable procedure of this package with specially crafted parameters and 
execute SQL statements with the elevated privileges of the SYS user.

Impact:
To exploit this vulnerability EXECUTE permission on the SYS.DBMS_CDC_PUBLISH 
package is required. By default users granted the EXECUTE_CATALOG_ROLE role 
have this permission granted. Exploitation of this vulnerability allows an 
attacker to execute SQL commands with SYS privileges.

Vendor Status:
Vendor was contacted and a patch was released.

Workaround:
Restrict access to the SYS.DBMS_CDC_PUBLISH package.

Fix:
Apply Oracle Critical Patch Update October 2010 available at Oracle Metalink.

CVE:
CVE-2010-2415

Links:
http://www.appsecinc.com/resources/alerts/oracle/2010-03.shtml
http://www.oracle.com/technetwork/topics/security/cpuoct2010-175626.html

Timeline:
Vendor Notification - 10/16/2009
Vendor Response - 10/22/2009
Fix - 10/12/2010
Public Disclosure - 10/13/2010

Application Security, Inc's database security solutions have helped over 2000 
organizations secure their databases from all internal and external threats 
while also ensuring that those organizations meet or exceed regulatory 
compliance and audit requirements.

Disclaimer: The information in the advisory is believed to be accurate at the 
time of publishing based on currently available information. Use of the 
information constitutes acceptance for use in an AS IS condition. There are no 
warranties with regard to this information. Neither the author nor the 
publisher accepts any liability for any direct, indirect, or consequential loss 
or damage arising from use of, or reliance on, this information.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.12 (MingW32)

iEYEARECAAYFAky3W8QACgkQRx91imnNIgHAAwCgwt3gB2IDlUbFgOw0AhLFRM1T
I9UAoNax7F1vmtk2EgAbbR6OLEbnOx8K
=K3D1
-----END PGP SIGNATURE-----

_______________________________________________
Full-Disclosure - We believe in it.
Charter: http://lists.grok.org.uk/full-disclosure-charter.html
Hosted and sponsored by Secunia - http://secunia.com/