From: Erik Wienhold <ewie@ewie.name>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: createuser unexpectedly creates superuser with createdb and createrole
Date: Tue, 5 Sep 2023 00:03:53 +0200 (CEST)
Message-ID: <498630446.200973.1693865033238@office.mailbox.org> (raw)
In-Reply-To: <1046709.1693791744@sss.pgh.pa.us>
References: <60174207.340484.1693356258123@office.mailbox.org>
<9ec51cd3b8d4d3402187cb89ca2afb3c99e64e48.camel@cybertec.at>
<1624623948.136031.1693791136215@office.mailbox.org>
<1046709.1693791744@sss.pgh.pa.us>
On 04/09/2023 03:42 CEST Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I think the last hunk of this is plenty sufficient, and the earlier
> ones just add noise.
Done.
--
Erik
Attachments:v2-0001-Document-implied-privileges-of-createuser-superus.patch (text/x-patch, 1.1K) download
From 7728fcab53c8e06c781f7347532cc8619799d8ff Mon Sep 17 00:00:00 2001
From: Erik Wienhold <ewie@ewie.name>
Date: Mon, 4 Sep 2023 23:50:33 +0200
Subject: [PATCH v2] Document implied privileges of createuser --superuser
Commit 8ae0d476a9 added option --superuser to createuser. In contrast
to CREATE ROLE, createuser also grants CREATEDB and CREATEROLE to new
superusers. This commit documents the implied privileges.
---
doc/src/sgml/ref/createuser.sgml | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/doc/src/sgml/ref/createuser.sgml b/doc/src/sgml/ref/createuser.sgmlindex 5c34c62342..03efeebe16 100644--- a/doc/src/sgml/ref/createuser.sgml+++ b/doc/src/sgml/ref/createuser.sgml@@ -275,7 +275,8 @@ PostgreSQL documentation
<term><option>--superuser</option></term>
<listitem>
<para>
- The new user will be a superuser.+ The new user will be a superuser. Also implies <option>--createdb</option>+ and <option>--createrole</option>.
</para>
</listitem>
</varlistentry>
--
2.42.0
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: ewie@ewie.name, tgl@sss.pgh.pa.us
Subject: Re: createuser unexpectedly creates superuser with createdb and createrole
In-Reply-To: <498630446.200973.1693865033238@office.mailbox.org>
References: <60174207.340484.1693356258123@office.mailbox.org> <9ec51cd3b8d4d3402187cb89ca2afb3c99e64e48.camel@cybertec.at> <1624623948.136031.1693791136215@office.mailbox.org> <1046709.1693791744@sss.pgh.pa.us> <498630446.200973.1693865033238@office.mailbox.org>
* 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