NGSSoftware Insight Security Research Advisory Name: Oracle audit issue with XMLDB ftp service Systems Affected: Oracle Oracle 9ir2, 10g Release 1 Severity: High Vendor URL: http://www.oracle.com/ Author: David Litchfield [ davidl (at) ngssoftware (dot) com [email concealed] ] Reported: 9th March 2006 Date of Public Advisory: 17th October 2007 Advisory number: #NISR17102007E Description *********** The Oracle XML DB ftp service contains problems with auditing logins. Details ******* When a user attempts to log in via the XDB ftp service the audit trail shows an incorrect entry for USERID. This can present two subtle problems. Firstly, if a user logs in as "SYSTEM" the USERID column only shows "SYSTE" - only 5 characters. The second problem is that if the same user then attempts to log in a user "FOO", "FOOTE" is logged in the USERID column - the "TE" coming from the "TE" of "SYSTE[M]" - the previous login. This only happens on the same connected TCP circuit; as such all audit entries have the same SESSIONID. Fix Information *************** Oracle was alerted to this flaw on the 9th of March 2006. A patch has now been made available: http://www.oracle.com/technology/deploy/security/critical-patch-updates/ cpuo ct2007.html NGSSQuirreL for Oracle, an advanced vulnerability assessment scanner designed specifically for Oracle, can be used to accurately determine whether your servers is vulnerable to this flaw. More information about NGSSQuirreL for Oracle can be found here: http://www.ngssoftware.com/products/database-security/ngs-squirrel-oracl e.ph p About NGSSoftware ***************** NGSSoftware develops vulnerability assessment and compliancy tools for database servers including Oracle, Microsoft SQL Server, DB2, Sybase and Informix. Headquartered in the United Kingdom NGS has offices in London, St. Andrews (UK), Brisbane, and Perth (Australia) and seattle in the United States; NGSConsulting provide services to some of the largest and most demanding organizations around the globe. http://www.ngssoftware.com/ Telephone +44 208 401 0070 Fax +44 208 401 0076 enquiries (at) ngssoftware (dot) com [email concealed] -- 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: 52 Throwley Way, Sutton, SM1 4BF with Company Number 04225835 and VAT Number 783096402