PG下如何创建对某个模式的表只读用户

郑全

比如创建一个只读用户readonlyuser,对APPUSER模式下所有表只读

--创建用户
create user readonlyuser password 'Pass@123';

--只读
alter user readonlyuser set default_transaction_read_only=on;

--授权
grant usage on schema appuser to readonlyuser;
grant select on all tables in schema appuser to readonlyuser;
--新增表读的权限
alter default privileges in schema appuser grant select on all tables to readonlyuser;