如何创建一个pgsql只读账户?
如何创建一个pgsql只读账户给all database all scheam select 权限
postgresql
数据库
赞
收藏 0
回答 2
待解决
https://www.cnblogs.com/liu-xiaoyi/p/12661166.html
创建普通的只读角色,并针对需要访问的SCHEMA和表赋予只读访问权限:
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA schema_name FROM readonly;
GRANT USAGE ON SCHEMA schema_name TO readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO readonly;
ALTER DEFAULT PRIVILEGES IN SCHEMA schema_name GRANT SELECT ON TABLES TO readonly;