pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Dominique Devienne <ddevienne@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Trouble with v16 new CREATEROLE semantic
Date: Thu, 15 Feb 2024 14:58:28 -0500
Message-ID: <Zc5s5KSHRI45YFaA@momjian.us> (raw)
In-Reply-To: <CAFCRh-9bSh6dRGa=AVWJ6y813xti4=SgFAbvAdOkFfNVNCG6wA@mail.gmail.com>
References: <CAFCRh-9bSh6dRGa=AVWJ6y813xti4=SgFAbvAdOkFfNVNCG6wA@mail.gmail.com>

On Thu, Feb 15, 2024 at 06:07:51PM +0100, Dominique Devienne wrote:
> When I read about v16, I thought great, this fits our intent, a single "owner"
> ROLE with CREATEROLE which is limited to administering only the ROLEs it
> created itself. I've always been bothered by the mega-power of CREATEROLE. But
> now that we're actually trying to use it, I'm a bit worried. Can someone
> explain (or guess) what I'm missing here?

Well, have you read the PG 16 release notes?

	https://www.postgresql.org/docs/current/release-16.html

You might also want to review my unreleased slide deck about users:

	https://momjian.us/main/writings/pgsql/user.pdf

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.





view thread (3+ messages)

Message-ID: <Zc5s5KSHRI45YFaA@momjian.us>
Permalink:  ../Zc5s5KSHRI45YFaA@momjian.us/
Also on:    postgresql.org/message-id/Zc5s5KSHRI45YFaA@momjian.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: bruce@momjian.us, ddevienne@gmail.com
  Subject: Re: Trouble with v16 new CREATEROLE semantic
  In-Reply-To: <Zc5s5KSHRI45YFaA@momjian.us>
  References: <CAFCRh-9bSh6dRGa=AVWJ6y813xti4=SgFAbvAdOkFfNVNCG6wA@mail.gmail.com> <Zc5s5KSHRI45YFaA@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox