Re: Additional info for CREATE ROLE with REPLICATION

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Additional info for CREATE ROLE with REPLICATION
Date: 2025-11-26 11:24:57
Message-ID: CAB-JLwY6SjCd=_W+FVhDWt1w3nyyaKbK5vs8ORGNK56rN+aq4Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Em ter., 25 de nov. de 2025 às 23:22, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2025-11-26 11:42:55 Re: Refactoring: Use soft error reporting for *_opt_overflow functions of date/timestamp
Previous Message Dilip Kumar 2025-11-26 11:18:50 Re: Proposal: Conflict log history table for Logical Replication