CREATE USER backup_user WITH ENCRYPTED PASSWORD ‘qux94874‘; GRANT CONNECT ON DATABASE foo_db to backup_user; GRANT CONNECT ON DATABASE bar_db to backup_user; \c foo GRANT USAGE ON SCHEMA public to backup_user; GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO backup_user; GRANT SELECT ON ALL TABLES IN SCHEMA public TO backup_user; \c bar GRANT USAGE ON SCHEMA public to backup_user; GRANT SELECT ON ALL SEQUENCES IN SCHEMA public TO backup_user; GRANT SELECT ON ALL TABLES IN SCHEMA public TO backup_user;
Create a readonly user in Postgres
原文：http://my.oschina.net/u/437581/blog/512058