-----BEGIN PGP SIGNED MESSAGE-----

===========================================================================
             AUSCERT External Security Bulletin Redistribution

           ESB-2002.363 -- Microsoft Security Bulletin MS02-038
       Cumulative Patch for SQL Server 2000 Service Pack 2 (Q316333)
                               25 July 2002

===========================================================================

        AusCERT Security Bulletin Summary
        ---------------------------------

Product:                Microsoft SQL Server 2000
                        Microsoft Desktop Engine (MSDE) 2000
Vendor:                 Microsoft
Operating System:       Windows
Impact:                 Execute Arbitrary Code/Commands

- --------------------------BEGIN INCLUDED TEXT--------------------

- -----BEGIN PGP SIGNED MESSAGE-----

- - ----------------------------------------------------------------------
Title:      Cumulative Patch for SQL Server 2000 Service Pack 2 
            (Q316333)
Date:       24 July 2002
Software:   Microsoft SQL Server 2000, Microsoft Desktop Engine 
            (MSDE) 2000
Impact:     Two vulnerabilities, both of which could enable an 
            attacker to run code on the server.
Max Risk:   Moderate
Bulletin:   MS02-038

Microsoft encourages customers to review the Security Bulletin at: 
http://www.microsoft.com/technet/security/bulletin/MS02-038.asp.
- - ----------------------------------------------------------------------

Issue:
======
This patch eliminates two newly discovered vulnerabilities affecting 
SQL Server 2000 and MSDE 2000:
 
 - A buffer overrun vulnerability that occurs in several Database 
   Consistency Checkers (DBCCs) that ship as part of SQL Server 2000.
   DBCCs are command console utilities that allow maintenance and 
   other operations to be performed on a SQL Server. While many of 
   these are executable only by sysadmin, some are executable by 
   members of the db_owner and db_ddladmin roles as well. In the most
   serious case, exploiting this vulnerability would enable an 
   attacker to run code in the context of the SQL Server service, 
   thereby giving the attacker complete control over all databases 
   on the server.
 
 - A SQL injection vulnerability that occurs in two stored 
   procedures used in database replication. One of these can only be 
   run by users who have been assigned the db_owner role; the other, 
   due to a permissions error, could be run by any user who could log
   onto the server interactively. Exploiting the vulnerability could 
   enable an attacker to run operating system commands on the server,
   but is subject to significant mitigating factors as discussed 
   below.

Mitigating Factors:
====================
Buffer Overrun Vulnerability in Database Consistency Checkers:
 
 - Both the db_owner and db_ddladmin roles carry with them 
   significant privileges, and only should be granted to trusted 
   users.
 
 - This allows the user to escalate privileges to the level of the 
   service account. And this escalation would be minimal if best 
   practices were followed and SQL were installed as a normal domain 
   account.
 
SQL Injection Vulnerability in Replication Stored Procedures:
 
 - Exploiting the vulnerability would, at a minimum, require that 
   the attacker have the ability to log onto the server 
   interactively. However, best practices strongly militate against 
   giving such permissions to untrusted users.
 
 - Simply being able to run the affected stored procedures would not 
   enable an attacker to exploit the vulnerability. As discussed in 
   the FAQ, the vulnerability could only be exploited if the 
   administrator had previously enabled the SQL Server Agent Proxy 
   account. By default, this account is disabled.
 
 - Even when enabled, the SQL Server Agent Proxy account has by 
   default only the privileges associated with a domain user. If 
   administrators follow best practices, it is likely that any user
   who could exploit the vulnerability would already have this level 
   of privilege.

Risk Rating:
============
 - Internet systems: Moderate
 - Intranet systems: Moderate
 - Client systems:   None

Patch Availability:
===================
 - A patch is available to fix this vulnerability. Please read the 
   Security Bulletin at
   http://www.microsoft.com/technet/security/bulletin/ms02-038.asp
   for information on obtaining this patch.

Acknowledgment:
===============
 - Cesar Cerrudo

- - ---------------------------------------------------------------------

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS 
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS 
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE 
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. 
IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE 
FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE 
POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION 
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES 
SO THE FOREGOING LIMITATION MAY NOT APPLY.

- -----BEGIN PGP SIGNATURE-----
Version: PGP 7.1

iQEVAwUBPT80d40ZSRQxA/UrAQGmUwf/T/2sIhvrwxbeQOxZxxyllnUo70DyScuW
zafKqyiMtpeQd9vilQdzvOke+ywyFUENZalxwCrTlrmfmKDTP928oOR08a4vXZKa
s6eASOM9LhpGsbXx+tYiu/hxfdJmGHzXnsKIKVeBSdwFloUT3DdcmFtBMOP8REg0
mrVsyv41nnSqtwOKJq0AxIn3f/cTK4FVfmUBUfDpkByAgvNfy6gFsO5avuRplX9v
fWdksv+BdgVCf03IqPOXerj8UkNOW+oKpmSfx66Q+bpB9YbhWazJmU2fKs9Vth20
yw3XB9O7ou3264d4UcJPoHmWcvMFNuWrJfhGmGzlvSnLIp/IFZgMOg==
=Fi4E
- -----END PGP SIGNATURE-----

- --------------------------END INCLUDED TEXT--------------------

You have received this e-mail bulletin as a result of your organisation's
registration with AusCERT. The mailing list you are subscribed to is
maintained within your organisation, so if you do not wish to continue
receiving these bulletins you should contact your local IT manager. If
you do not know who that is, please send an email to auscert@auscert.org.au
and we will forward your request to the appropriate person.

This security bulletin is provided as a service to AusCERT's members.  As
AusCERT did not write the document quoted above, AusCERT has had no control
over its content.  The decision to use any or all of this information is
the responsibility of each user or organisation, and should be done so in
accordance with site policies and procedures.

NOTE: This is only the original release of the security bulletin.  It may
not be updated when updates to the original are made.  If downloading at
a later date, it is recommended that the bulletin is retrieved directly
from the original authors to ensure that the information is still current.

Contact information for the authors of the original document is included
in the Security Bulletin above.  If you have any questions or need further
information, please contact them directly.

Previous advisories and external security bulletins can be retrieved from:

	http://www.auscert.org.au/Information/advisories.html

If you believe that your system has been compromised, contact AusCERT or
your representative in FIRST (Forum of Incident Response and Security
Teams).

Internet Email: auscert@auscert.org.au
Facsimile:	(07) 3365 7031
Telephone:	(07) 3365 4417 (International: +61 7 3365 4417)
		AusCERT personnel answer during Queensland business hours
		which are GMT+10:00 (AEST).
		On call after hours for member emergencies.

-----BEGIN PGP SIGNATURE-----
Version: 2.6.3i
Charset: noconv
Comment: ftp://ftp.auscert.org.au/pub/auscert/AUSCERT_PGP.key

iQCVAwUBPUAhryh9+71yA2DNAQH/cwP/biRXRXkuOoqgadHG1tvJwSrOrAFfc9T7
zRbmLQRs/wvJi+c7mjQt0NUxiQSYux7oB3aSDsYqzXXpnGNK4WihIIySzn6lWXUv
kZz7fTfu1ci05ie6sE7NBVvDzDzfoBqA4RI+zOwpZw1bqVsPLRrlb48F+2ds3+j8
xKYbrm/gpUE=
=6suB
-----END PGP SIGNATURE-----