amb-monitor/db/migrations/000006_create_readonly_user...

8 lines
247 B
SQL

CREATE ROLE readonly;
GRANT CONNECT ON DATABASE db TO readonly;
GRANT USAGE ON SCHEMA public TO readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;
CREATE USER read_user WITH PASSWORD 'read_user_pass';
GRANT readonly TO read_user;