Create Read Only User in PostgreSQL

1
2
3
4
5
6
7
8

Time: 4.454s (4 seconds), executed in: 4.001s (4 seconds)
raw_test_data> CREATE USER prog_create_figures WITH PASSWORD 'hs2readonly';
CREATE ROLE
Time: 0.026s
raw_test_data> GRANT pg_read_all_data TO prog_create_figures;
GRANT ROLE
Time: 0.005s
raw_test_data>