From: "David Litchfield" <davidl@ngssoftware.com.>
To: <full-disclosure@lists.grok.org.uk.>, <bugtraq@securityfocus.com.>
Subject: Trigger Abuse of MDSYS.SDO_TOPO_DROP_FTBL in Oracle 10g R1 and R2
Date: Tue, 13 Jan 2009 23:52:02 -0000
MIME-Version: 1.0
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
reply-type=original
Content-Transfer-Encoding: quoted-printable
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4325
X-OriginalArrivalTime: 13 Jan 2009 23:52:54.0630 (UTC) FILETIME=[0D7BB060:01C975DA]
X-Virus-Scanned: antivirus-gw at tyumen.ru
NGSSoftware Insight Security Research Advisory
Name: Trigger abuse of MDSYS.SDO_TOPO_DROP_FTBL
Systems Affected: Oracle 10g R1 and R2 (10.1.0.5 and 10.2.0.2)
Severity: High
Vendor URL: http://www.oracle.com/
Author: David Litchfield [ [email protected] ]
Reported: 23rd July 2008
Date of Public Advisory: 13th January 2009
Advisory number: #NISR13012009
CVE: CVE-2008-3979
Overview
********
Oracle has just released a fix for a flaw that, when exploited, allows a =
low=20
privileged authenticated database user to gain MDSYS privileges. This =
can be=20
abused by an attacker to perform actions as the MDSYS user.
Details
*******
MDSYS.SDO_TOPO_DROP_FTBL is one of the triggers that forms part of the=20
Oracle Spatial Application. It is vulnerable to SQL injection. When a =
user=20
drops a table the trigger fires. The name of the table is embedded in a=20
dynamic SQL query which is then executed by the trigger. Note that the=20
Oracle advisory states that the attacker requires the DROP TABLE and =
CREATE=20
PROCEDURE privileges. This is not the case and only CREATE SESSION=20
privileges are required.
Fix Information
***************
Oracle was alerted to this flaw on the 23rd July 2008. A patch has now =
been=20
made available:
http://www.oracle.com/technology/deploy/security/critical-patch-updates/c=
pujan2009.html
NGSSQuirreL for Oracle, an advanced vulnerability assessment scanner=20
designed specifically for Oracle, can be used to accurately determine=20
whether your servers are vulnerable to these flaws. More information =
about=20
NGSSQuirreL for Oracle can be found here:
http://www.ngssoftware.com/products/database-security/ngs-squirrel-oracle=
php
About NGSSoftware
*****************
NGSSoftware, an NCC Group Company, develops vulnerability assessment and =
compliancy tools for database servers including Oracle, Microsoft SQL=20
Server, DB2, Sybase and Informix. Headquartered in the United Kingdom =
NGS=20
has offices in London, St. Andrews (UK), Brisbane, and Perth (Australia) =
and=20
Seattle in the United States; NGS provide services to some of the =
largest=20
and most demanding organizations around the globe.
http://www.ngssoftware.com/
Telephone +44 208 401 0070
Fax +44 208 401 0076
--
E-MAIL DISCLAIMER
The information contained in this email and any subsequent
correspondence is private, is solely for the intended recipient(s) and
may contain confidential or privileged information. For those other than
the intended recipient(s), any disclosure, copying, distribution, or any
other action taken, or omitted to be taken, in reliance on such
information is prohibited and may be unlawful. If you are not the
intended recipient and have received this message in error, please
inform the sender and delete this mail and any attachments.
The views expressed in this email do not necessarily reflect NGS policy.
NGS accepts no liability or responsibility for any onward transmission
or use of emails and attachments having left the NGS domain.
NGS and NGSSoftware are trading names of Next Generation Security
Software Ltd. Registered office address: Manchester Technology Centre,
Oxford Road, Manchester, M1 7EF with Company Number 04225835 and
VAT Number 783096402