Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qSQOG-005j5M-UM for pgsql-hackers@arkaria.postgresql.org; Sat, 05 Aug 2023 23:08:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qSQOE-001jPA-3U for pgsql-hackers@arkaria.postgresql.org; Sat, 05 Aug 2023 23:08:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qSQOD-001jP1-Iu for pgsql-hackers@lists.postgresql.org; Sat, 05 Aug 2023 23:08:54 +0000 Received: from mail-yb1-xb29.google.com ([2607:f8b0:4864:20::b29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qSQOA-000kV6-Ia for pgsql-hackers@postgresql.org; Sat, 05 Aug 2023 23:08:52 +0000 Received: by mail-yb1-xb29.google.com with SMTP id 3f1490d57ef6-d299ed34bacso6344593276.1 for ; Sat, 05 Aug 2023 16:08:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1691276930; x=1691881730; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=bejEpfkvnUW3zS9fc1RNa1djDp/tKoPxJZmb8cRDbyc=; b=f4flviW7SOEEadlZCDmwvC9W6c9/Uu4Y+lb9aGE1f9n7lNfMCjvFetrcM5sYD4hn2E huoleSFVFQwyVQgv53AlNc3eFOjXIdVBipb7Dz5YU7qaKOhZnfVw6PKkL4JwX9cXNMJ6 KePQxyMJwECuqb6AzcHkgULDrpRSw1RqYYGLo= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691276930; x=1691881730; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=bejEpfkvnUW3zS9fc1RNa1djDp/tKoPxJZmb8cRDbyc=; b=dItRqFLLFADKrij441EbC484m86w3nPHawFVmZrA9wZw90A/RQlZCi+MZksvdCbpLI KvSbOHuWLXXg9dL4pRF6+8vsNzZeDjDJpzXEgg0hD1lXzZ6oyKmTDL5hfW+NUVEgAxhP Fs/srRBl7VuK0kJsm6Rb7Fofyfs36D0tzctIZY3g62voUhLNP97ZPMgMXFMbRIozZxmE K9f8QCnp1nRfIyUnRJ8L7f5hOewfZBqviLaq79tqMeDFsb8B9hn9J+bK8vcATDiqnlB9 EipWTWMosiEUbIbqXoDze5boqwcdZjR54iNkKDI0UQkkdsRzUvkzzpWjCsYCX3SAiDoR Lqxw== X-Gm-Message-State: AOJu0Yxk0hwEtQKnWJl1jzsw8go0RQWixwvD+Md+aWmbqt4ZVsyhYDK5 O84eJbtaqKcyD8gPouPYGlt7VQ== X-Google-Smtp-Source: AGHT+IFzMJ92Pq3FV0nwx6zPwXyavoXLZT8Et1PoCkU5NKkDGBcjnLZYq95I+yYA92IFXkAq0Tu48w== X-Received: by 2002:a0d:d44a:0:b0:583:9935:b8ba with SMTP id w71-20020a0dd44a000000b005839935b8bamr3673833ywd.6.1691276929868; Sat, 05 Aug 2023 16:08:49 -0700 (PDT) Received: from rfd.leadboat.com ([2600:1702:a20:5750::2e]) by smtp.gmail.com with ESMTPSA id w128-20020a0ded86000000b00583f8f41cb8sm1729328ywe.63.2023.08.05.16.08.48 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 05 Aug 2023 16:08:49 -0700 (PDT) Date: Sat, 5 Aug 2023 16:08:47 -0700 From: Noah Misch To: Bruce Momjian Cc: PostgreSQL-development Subject: Re: PG 16 draft release notes ready Message-ID: <20230805230847.GA1370050@rfd.leadboat.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, May 18, 2023 at 04:49:47PM -0400, Bruce Momjian wrote: > https://momjian.us/pgsql_docs/release-16.html > > > > > Restrict the privileges of CREATEROLE roles (Robert Haas) > > > > Previously roles with CREATEROLE privileges could change many aspects of any non-superuser role. Such changes, including adding members, now require the role requesting the change to have ADMIN OPTION > permission. > > > > > > > > Improve logic of CREATEROLE roles ability to control other roles (Robert Haas) > > > > For example, they can change the CREATEDB, REPLICATION, and BYPASSRLS properties only if they also have those permissions. > > CREATEROLE is a radically different feature in v16. In v15-, it was an almost-superuser. In v16, informally speaking, it can create and administer its own collection of roles, but it can't administer roles outside its collection or grant memberships or permissions not offered to itself. Hence, let's move these two into the incompatibilities section. Let's also merge them, since f1358ca52 is just doing to clauses like CREATEDB what cf5eb37c5 did to role memberships. > > > > > Allow GRANT to control role inheritance behavior (Robert Haas) > > > > By default, role inheritance is controlled by the inheritance status of the member role. The new GRANT clauses WITH INHERIT and WITH ADMIN can now override this. > > > > > > > > Allow roles that create other roles to automatically inherit the new role's rights or SET ROLE to the new role (Robert Haas, Shi Yu) > > > > This is controlled by server variable createrole_self_grant. > > Similarly, v16 radically changes the CREATE ROLE ... WITH INHERIT clause. The clause used to "change the behavior of already-existing grants." Let's merge these two and move the combination to the incompatibilities section. > Remove libpq support for SCM credential authentication (Michael Paquier) Since the point of removing it is the deep unlikelihood of anyone using it, I wouldn't list this in "incompatibilities". > Deprecate createuser option --role (Nathan Bossart) This is indeed a deprecation, not a removal. By the definition of "deprecate", it's not an incompatibility.