Oracle TZ_OFFSET Remote System Buffer Overrun (#NISR16022003c)

From: NGSSoftware Insight Security Research (nisr@NEXTGENSS.COM)
Date: 02/17/03

  • Next message: NGSSoftware Insight Security Research: "Oracle9i Application Server Format String Vulnerability (#NISR16022003d)"
    Date:         Mon, 17 Feb 2003 14:15:06 -0800
    From: NGSSoftware Insight Security Research <nisr@NEXTGENSS.COM>
    To: NTBUGTRAQ@LISTSERV.NTBUGTRAQ.COM
    
    

    NGSSoftware Insight Security Research Advisory

    Name: Oracle TZ_OFFSET Remote System Buffer Overrun
    Systems Affected: All platforms; Oracle9i Database Release 2, 9i Release 1,
    8i, 8.1.7, 8.0.6
    Severity: High Risk
    Category: Remote System Buffer Overrun
    Vendor URL: http://www.oracle.com
    Author: Mark Litchfield (mark@ngssoftware.com)
    Date: 16th February 2003
    Advisory number: #NISR16022003c

    Description
    ***********
    Oracle's database server contains fuctions for use within queries. The
    TZ_OFFSET function returns the time zone offset corresponding to the value
    entered based on the date the statement was executed. For example:

    SELECT TZ_OFFSET('US/Eastern') FROM DUAL;

    would return the time zone offset value of -04:00. The TZ_OFFSET() function
    contains a remotely exploitable buffer overflow vulnerability.

    Details
    *******
    There exists a remotely exploitable buffer overflow vulnerability in the
    TZ_OFFSET function. By supplying a long character string for the time zone
    name an attacker can overwrite a saved return address on the stack of Oracle
    process. Before this issue can be exploited an attacker must be able to log
    on to the database server with a valid user ID and password, but as the
    TO_TIMESTAMP_TZ() function can be executed by PUBLIC by default any user of
    the system can gain control. Any arbitrary code supplied by an attacker
    would execute with the same privileges as the user running the service; this
    account is typically "Oracle" on linux/unix based platforms and Local System
    on Windows based operating systems such as NT/2000/XP. As such this allows
    for a complete compromise of the data stored in the database and possibly a
    complete compromise of the operating system.

    Fix Information
    ***************
    NGSSoftware alerted Oracle to this vulnerability on 30th September 2002.
    Oracle has developed a patch which is available from

    http://otn.oracle.com/deploy/security/pdf/2003alert50.pdf

    A check for these issues has been added to NGSSQuirreL for Oracle, a
    comprehensive automated vulnerability assessment tool for Oracle Database
    Servers of which more information is available from the NGSSite

    http://www.ngssoftware.com/software/squirrelfororacle.html

    Further Information
    *******************
    For further information about the scope and effects of buffer overflows,
    please see

    http://www.ngssoftware.com/papers/non-stack-bo-windows.pdf
    http://www.ngssoftware.com/papers/ntbufferoverflow.html
    http://www.ngssoftware.com/papers/bufferoverflowpaper.rtf
    http://www.ngssoftware.com/papers/unicodebo.pdf

    About NGSSoftware
    *****************
    NGSSoftware design, research and develop intelligent, advanced application
    security assessment scanners. Based in the United Kingdom, NGSSoftware have
    offices in the South of London and the East Coast of Scotland. NGSSoftware's
    sister company NGSConsulting, offers best of breed security consulting
    services, specialising in application, host and network security
    assessments.

    http://www.ngssoftware.com/
    http://www.ngsconsulting.com/

    Telephone +44 208 401 0070
    Fax +44 208 401 0076

    enquiries@ngssoftware.com

    oooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
    Delivery co-sponsored by TruSecure Corporation
    oooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
    TICSA - Anniversary Special - Limited Time

    Become TICSA certified for just $221.25 US when you register before 3/31/03
    with PROMO "TS0103" at www.2test.com. NO membership fees, certification
    good for 2 years. Price for international delivery just $296.25 US, with
    this offer. Offer cannot be combined with any other special and expires
    3/31/03. Visit www.trusecure.com/ticsa for full details.

    oooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo



    Relevant Pages

    • [NEWS] Oracle Unauthenticated Remote System Compromise
      ... Beyond Security would like to welcome Tiscali World Online ... Oracle is the leader in the database market with a 54% market share lead ... There is a remotely exploitable buffer overflow vulnerability in the ... authentication process with the Oracle Database Server. ...
      (Securiteam)
    • Oracle TO_TIMESTAMP_TZ Remote System Buffer Overrun (#NISR16022003b)
      ... Oracle TO_TIMESTAMP_TZ Remote System Buffer Overrun ... Oracle's database server contains fuctions for use within queries. ... By supplying a long character string for the second parameter an attacker ...
      (NT-Bugtraq)
    • Re: timezone - dst calendar questions
      ... Oracle Enterprise Manager agent were broken. ... HPUX box then compared the timestamp shown by 'ls -l' ... Perhaps the system time zone is wrongly set. ...
      (comp.unix.admin)
    • Re: ORA-01031
      ... MY Database Server is installed in Windows 2000 Server, Oracle 10g. ... review the trace to determine the statement causing the error ...
      (comp.databases.oracle.misc)
    • RE: DBI fetch gets SEGEMENTATION FAULT with new ORACLE date data type(TIMESTAMP WITH LOCAL TIME ZON
      ... guess a oracle bug) in utilizing this feature with Oracle 8i client. ... Although with 9i client it works just fine. ... TIMESTAMP WITH LOCAL TIME ZONE doesn't return correct time zone value using ... > data type. ...
      (perl.dbi.users)