pg(PostgreSQL) 查询账号的表权限

1. 查询表权限分给了哪些账号

select * from information_schema.table_privileges  where table_name  like '表名';

2. 查询账号有哪些表的权限

# 查账号所拥有的权限
select * from information_schema.role_table_grants where grantee='someone';
# 或者
select * from information_schema.table_privileges where grantee='someone';