Oracle ANSI outer join syntax in SQL queries can be used to bypass ACLs
| oracle-ansi-sql-bypass-acl (8855) |  Medium Risk |
Description:
Oracle9i Database Server could allow a remote attacker to bypass database restrictions. A remote attacker with limited database privileges could create a SQL query that uses the ANSI (American National Standards Institute) outer join syntax to gain unauthorized access to restricted data.
Platforms Affected:
- Oracle, Database Server 9.0
- Oracle, Database Server 9.0.1
Remedy:
Apply the patch for this vulnerability, as listed in Oracle Security Alert #33. See References.
Consequences:
Bypass Security
References:
- BugTraq Mailing List, Tue Apr 16 2002 - 10:24:45 CDT, ansi outer join syntax in Oracle allows access to any data at http://archives.neohapsis.com/archives/bugtraq/2002-04/0175.html.
- CIAC Information Bulletin M-071, Oracle9i User Privileges Vulnerability at http://www.ciac.org/ciac/bulletins/m-071.shtml.
- Oracle Security Alert #33, User Privileges Vulnerability in Oracle9i Database Server at http://otn.oracle.com/deploy/security/pdf/sql_joins_alert.pdf.
- BID-4523: Oracle 9i ANSI Outer Join Access Control Bypass Vulnerability
- CVE-2002-0571: Oracle Oracle9i database server 9.0.1.x allows local users to access restricted data via a SQL query using ANSI outer join syntax.
- OSVDB ID: 5236: Oracle ANSI Outer Join SQL Query Information Disclosure
Reported:
Apr 16, 2002
The information within this database may change without notice. Use of this information constitutes acceptance for use in an AS IS condition. There are NO warranties, implied or otherwise, with regard to this information or its use. Any use of this information is at the user's risk. In no event shall the author/distributor (Internet Security Systems X-Force) be held liable for any damages whatsoever arising out of or in connection with the use or spread of this information.
Copyright (c) 1994-2008 Internet Security Systems, Inc. All rights reserved worldwide.
For corrections or additions please email xforce@iss.net