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 1r5Ycs-00Dyqu-R4 for pgsql-docs@arkaria.postgresql.org; Tue, 21 Nov 2023 21:49:46 +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 1r5Ycr-002cZA-EL for pgsql-docs@arkaria.postgresql.org; Tue, 21 Nov 2023 21:49:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r5Ycr-002cZ2-6M for pgsql-docs@lists.postgresql.org; Tue, 21 Nov 2023 21:49:45 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r5Yck-007fvF-7f for pgsql-docs@lists.postgresql.org; Tue, 21 Nov 2023 21:49:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062407; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:To:From:Date:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description; bh=0bH3S6ADAwVd6kAjvi8mD2dlXn4l7bxQwxOspO9dbCY=; b=Eh1XM jDKDBF0urWo16G1n4QWukhwVKDX3aj/X2TRcJ6YPzsfocrFRIYUxTnE4s8lszvW1v0ENZuas1eEj/ vdtgWAxoquk4KHngp/W8FwnFBhP79/KePU1ZOxc70L6kf9xH/jnjDpQ99yotpBpvHkJ5ugpRBEreN 784aQSGwQQkW8Pihzh/ZD4zM+ORBJhcE3fchtYEdefsaqw8n4xGi7A701h68rKYQVIsemHge1ROyA pQeKFdGs4Dd7M+k49g87//1HI9Ay9doaQdLaKxJNF1dxGteQiZ363YRC2pg6gCA3R6qzXWzX96BlW FBkkyDJcu6RsO/LNmzI6Duw/6AcTw==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1r5Ycj-0072a1-0N; Tue, 21 Nov 2023 16:49:37 -0500 Date: Tue, 21 Nov 2023 16:49:37 -0500 From: Bruce Momjian To: rightfold@gmail.com, pgsql-docs@lists.postgresql.org Subject: Re: Documentation of FOR ROLE clause of ALTER DEFAULT PRIVILEGES missing Message-ID: References: <151932901967.3883.15879720134835023834@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <151932901967.3883.15879720134835023834@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Feb 22, 2018 at 07:50:19PM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/sql-alterdefaultprivileges.html > Description: > > The documentation of ALTER DEFAULT PRIVILEGES statements seems to lack an > elaboration of the FOR ROLE clause. > > It specifies what restrictions exist (namely "The name of an existing role > of which the current role is a member."), but what the specified role is > actually used for remains a mystery. > > The documentation should read something like: "The default permissions are > only granted on objects created by this role." I know this is five years late, but we fixed this issue and the new docs will appear in Postgres 17: https://www.postgresql.org/docs/devel/sql-alterdefaultprivileges.html We felt the doc rewrite was too extensive to backpatch. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.