Postgresql 只读角色和用户

PostgreSQL 只读角色和用户

sql
CREATE ROLE readonly;

sql
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;

sql
CREATE USER readonly_user WITH PASSWORD 'password';

sql
GRANT readonly TO readonly_user;

sql
psql -U readonly_user -d your_database

sql
-- 创建只读角色
CREATE ROLE readonly;
-- 授予只读权限
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;
-- 创建只读用户
CREATE USER readonly_user WITH PASSWORD 'password';
-- 将只读用户关联到只读角色
GRANT readonly TO readonly_user;

sql
psql -U readonly_user -d your_database