--postgresql 授权给用户只读权限

CREATE USER aypc WITH ENCRYPTED PASSWORD 'aypc';

alter user aypc set default_transaction_read_only=on;

GRANT USAGE ON SCHEMA axpay to aypc;

ALTER DEFAULT PRIVILEGES IN SCHEMA axpay GRANT SELECT ON TABLES TO aypc;

GRANT CONNECT ON DATABASE pcd to aypc;

GRANT USAGE ON SCHEMA axpay to aypc;

GRANT SELECT ON ALL SEQUENCES IN SCHEMA axpay TO aypc;

GRANT SELECT ON ALL TABLES IN SCHEMA axpay TO aypc;