kingbase创建只读用户

最新推荐文章于 2025-10-24 16:04:10 发布

原创最新推荐文章于 2025-10-24 16:04:10 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #postgresql

kingbase 专栏收录该内容

20 篇文章

订阅专栏

本文详细介绍了如何在数据库中为read-only用户创建并分配权限，包括设置加密密码、限制事务读写、授权公共schema中的表和序列访问。

CREATE USER readonly WITH ENCRYPTED PASSWORD '123456';
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 test to readonly;
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;