PostgresSQL创建一个只读用户

create user readonlyuser with password 'R3333333341';

grant select on all tables in schema public to readonlyuser;

单表授权
GRANT SELECT ON tablename to readonlyuser