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.
Consequences:
Bypass Security
Remedy:
Apply the patch for this vulnerability, as listed in Oracle Security Alert #33. See References.
References:
- BugTraq Mailing List, Tue Apr 16 2002 - 10:24:45 CDT: ansi outer join syntax in Oracle allows access to any data.
- CIAC Information Bulletin M-071: Oracle9i User Privileges Vulnerability.
- Oracle Security Alert #33: User Privileges Vulnerability in Oracle9i Database Server.
- 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 Database Server ANSI Outer Join SQL Query Information Disclosure
Platforms Affected:
- Oracle Database Server 9.0
- Oracle Database Server 9.0.1
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 (IBM 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.
For corrections or additions please email ignore thisxforceignore this@ignore thisus.ignore thisibm.comignore this