Postgresql-创建只读用户

Postgresql-创建只读用户

create user bigdata with password 'ch2)x7jzReZN';
alter user bigdata set default_transaction_read_only=on;
GRANT USAGE ON SCHEMA public to bigdata;
grant select on all tables in schema public to bigdata;