pg(PostgreSQL) 设置账号只能查询部分字段

结论: pg无法直接在字段级别上做权限控制, 可通过视图实现

示例:

1. 创建账号

create user popo password 'p1o1p2o2';

2. 将可访问字段抽成视图

CREATE VIEW "oo"."customer_view" AS  SELECT customer.id,
    customer.level,
    customer.status
   FROM oo.customer;

3. 对模式和视图授权

grant usage on schema oo to popo;
grant select on oo.customer_view to popo;