pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.sgml index 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

view thread (6+ messages)  latest in thread

Message-ID: <498630446.200973.1693865033238@office.mailbox.org>
Permalink:  ../498630446.200973.1693865033238@office.mailbox.org/
Also on:    postgresql.org/message-id/498630446.200973.1693865033238@office.mailbox.org

 ·  · 

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: 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