Horton

Re: Additional info for CREATE ROLE with REPLICATION

Marcos Pegoraro <marcos@f10.com.br>

View thread
From: Marcos Pegoraro <marcos@f10.com.br>
To: Chao Li <li.evan.chao@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-11-26T11:24:57Z
Lists: pgsql-hackers 
Em ter., 25 de nov. de 2025 às 23:22, Chao Li <li.evan.chao@gmail.com>
escreveu:

> > <0001-Master - Additional info for create role with REPLICATION.diff>
>

ok, I understand that, but the REPLICATION paragraph says "A role having
the REPLICATION attribute is a very highly privileged role". So the user
thinks, well, if this role is a highly privileged role, he should have
SELECT permission automatically, right ? And it does not, so a warning like
this would be fine, I think.

regards
Marcos