postgres创建只读用户

  1. 创建只读角色
CREATE ROLE readaccess;
  1. 授予对现有表的访问权限
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;
  1. 授予后面新增表的访问权限
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;
  1. 创建用户
CREATE USER testuser WITH PASSWORD 'mypassword';
GRANT readaccess TO testuser;
版权声明：本文为weixin_42539198原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。