TIL

pg_read_all_data role in Postgres 14+

Postgres 14 has a read-only role built-in (full list of predefined roles here).

GRANT pg_read_all_data TO myuser;