TIL
Create Read Only User in PostgreSQL

Create Read Only User in PostgreSQL

April 6, 2025

I did this for Create Figures. The goal is that each program will have its own user.

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>
Using a Data Dictionary as Your Roadmap to Quality DataPractical Decorators