Postgres create readonly account case

来源:互联网 发布:js防止跨站脚本攻击 编辑:程序博客网 时间:2024/06/06 02:49
CREATE USER swiftlive_read_only with PASSWORD '111111';
ALTER USER swiftlive_read_only set default_transaction_read_only = on;
GRANT CONNECT on database  swiftlive_prod to swiftlive_read_only with grant option;
\c  swiftlive_prod;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO swiftlive_read_only;
0 0