【转载】Postgres创建只读权限的角色

2022-07-26  本文已影响0人  pumpdev
CREATE USER readonly WITH ENCRYPTED PASSWORD 'Test@1234';
alter user readonly set default_transaction_read_only=on;
GRANT USAGE ON SCHEMA public to readonly;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readonly;
GRANT CONNECT ON DATABASE demo to readonly;
\c demo
GRANT USAGE ON SCHEMA public to readonly;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;

转载自:博客园

上一篇 下一篇

猜你喜欢

热点阅读