博客

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


;