TIL

pg_read_all_data role in Postgres 14+

Shared by avatar for Peter Baumgartner Peter Baumgartner on 

  • tags:
  • #postgres

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

GRANT pg_read_all_data TO myuser;