Microsoft Security Advisory MS02-061 - Microsoft SQL Server 7.0 and 2000 contain stored procedures which allow low privileged users who are able to authenticate to a SQL server to delete, insert or update all the web tasks created by other users. In addition, the attacker can run already created web tasks in the context of the creator of the web task, usually the SQL Server Agent service account.
b64e0c0e18bee283ad6b70b6b0638fbfd75ccd565bbd4d21fec435e3209cbf49
-----BEGIN PGP SIGNED MESSAGE-----
- ----------------------------------------------------------------------
Title: Elevation of Privilege in SQL Server Web Tasks (Q316333)
Released: 16 October 2002
Software: Microsoft SQL Server 7.0 and 2000
Impact: Elevation of privilege
Max Risk: Critical
Bulletin: MS02-061
Microsoft encourages customers to review the Security Bulletin at:
http://www.microsoft.com/technet/security/bulletin/MS02-061.asp.
- ----------------------------------------------------------------------
Issue:
======
SQL Server 7.0 and 2000 provide stored procedures which is a coll-
ection of Transact-SQL statements stored under a name and processed
as a group. One stored procedure, an extended stored procedure and
weak permissions on a table combine to allow a low privileged user
the ability to run, delete, insert or update web tasks.
An attacker who is able to authenticate to a SQL server could delete,
insert or update all the web tasks created by other users. In
addition, the attacker could run already created web tasks in the
context of the creator of the web task. This typically runs in the
context of the SQL Server Agent service account.
Mitigating Factors:
====================
- - It is necessary to be an authenticated user of the SQL Server.
- - Exploiting this vulnerability could allow the attacker to escalate
privileges to the level of the SQL Server service account. By
default, the service runs with the privileges of a domain user,
rather than with system privileges.
- - Web tasks have to exist in the first place.
Risk Rating:
============
- Internet systems: Critical
- Intranet systems: Critical
- 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-061.asp
for information on obtaining this patch.
Acknowledgment:
===============
- Microsoft thanks David Litchfield of Next Generation Security
Software Ltd. for reporting this issue to us and working with
us to protect customers. We would also like to thank Martin
Rakhmanoff (jimmers@yandex.ru) for contributing to the
investigation.
- ---------------------------------------------------------------------
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
iQEVAwUBPa3z6Y0ZSRQxA/UrAQFWOQf/YE4HJMZ7ez1BC9n3W2DRI9BpQVGw2s4N
ALAcn2EprvU+jh4GUAuO9DilsNS/QjSsox6SFszjKJQih48xZTTXqnAocexC/8QV
iK0x97xnqGA7+zgM7XGyKnUIOaEJZzTLyvY/qY5gmWZRTyqQsDrO+xUN3JecgPsU
EYIkCINtLC51tRbFdK0NE3wlARcmamXFbkkm0ZeHh/ogh4pyLvXhHnabGPYMDuoB
2CDzOGpbMaI+PNRF2ZaVS4BlDfvR1jutizBQ9420HreFc7A6CWhu4WECtQzlHVNX
r+WnaC3PidLv8tYAMFnHf7Y1hU/1w/l/R0MK2+oOn/JKsWnB7bgG1w==
=FwnJ
-----END PGP SIGNATURE-----