Oracle ANSI outer join syntax in SQL queries can be used to bypass ACLs

oracle-ansi-sql-bypass-acl (8855) The risk level is classified as MediumMedium Risk


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.


Bypass Security


Apply the patch for this vulnerability, as listed in Oracle Security Alert #33. See References.


Platforms Affected:

  • Oracle Database Server 9.0
  • Oracle Database Server 9.0.1


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

Return to the main page