1

create user zhangyou with encrypted password '123456';

1

alter user zhangyou set default_transaction_read_only=on;

1

2

grant usage on schema public to zhangyou;

alter default privileges in?schema public grant select on tables to?zhangyou;

1

grant connect on database test to?zhangyou;

1

\c test?

1

2

3

GRANT USAGE ON SCHEMA public to?zhangyou;

GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO?zhangyou;

GRANT SELECT ON ALL TABLES IN SCHEMA public TO?zhangyou;