On Tuesday, December 9, 2025, richard coleman <
rcoleman.ascentgl@gmail.com> wrote:
In PostgreSQL 16+ the built in roles such as pg_read_all_data and pg_write_all_data are a welcome addition to permission setting in PostgreSQL.
Unfortunately they appear to be server-wide roles.
Woud it be possible to have roles like these that are database specific?
You can have roles that are database-specific; which then means those roles can only apply the “all data” privileges within the database they are permitted access to.
David J.