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.96) (envelope-from ) id 1w2f7X-000U9G-2B for pgsql-bugs@arkaria.postgresql.org; Wed, 18 Mar 2026 00:50:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2f7W-006HEI-1G for pgsql-bugs@arkaria.postgresql.org; Wed, 18 Mar 2026 00:50:46 +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.96) (envelope-from ) id 1w2f7W-006HE9-0E for pgsql-bugs@lists.postgresql.org; Wed, 18 Mar 2026 00:50:46 +0000 Received: from mail-ot1-x334.google.com ([2607:f8b0:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2f7T-00000000mDS-0sAv for pgsql-bugs@lists.postgresql.org; Wed, 18 Mar 2026 00:50:45 +0000 Received: by mail-ot1-x334.google.com with SMTP id 46e09a7af769-7d738fe814cso4981103a34.3 for ; Tue, 17 Mar 2026 17:50:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773795037; x=1774399837; darn=lists.postgresql.org; h=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=NZqk+Z7creh5PiFFnUjXdqRUdbsfzX4+2jc+I4gudms=; b=EVGKDh67ZIOhwEg+mOhTI/6KzIxKZDJxHvsRDv/Q/ZSQsq5X/lnXS85eKSt5i+itLD 2Tb1mGL+xijB/CyAy4m/7mhJkGActg3sMZrx2wfppIwES9Dm7jaR07r7usol1Ybgkyny g8n6NetAxNvuvWwZBGTTjd3ZPxNczaHcPmf5rAkhzfUs+YQ7Psy9WeGj5cr/jIIwCnnE Q3vO6DevvsoT3kYcG+39xbEae9T2Rr+f89tz9q3gTkP41OcllF0XB6c5XAQOxWLBovXe g39XUNvr7lEktdQkEpaQtIPvnpFgc8iJsRkWAjpr7acHjxS21R9Xkj61goAj/ClRQRwi BuGQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773795037; x=1774399837; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=NZqk+Z7creh5PiFFnUjXdqRUdbsfzX4+2jc+I4gudms=; b=m8oGH0E0ix9KgxM9szj8+JMQ9RjeJIQmHyMS/qXrHQAEFAZKLAZ36zmSyC5ClXMIyA zdhbEMlfRcJl6oJYdcz2fAdNsVaSgSCJm5bLNT7HYcDKrJs0CF34X5IYEMGXr5aU2DiQ XH2Uc3WOISJiCDKNifnzMfFMTIyRymhjHy4+LL/vVLCNJAJlPM7K35OET2IVaVc/gbOd qcky/deLvgFXNgXq4U7DZxc3MbODDfvZyFX0HY2DHbMKwgZLyiGS5ByeLnpn1rO6VxT5 OcQpCj6hNATXiTS4+iu6P2mdb15acmNuSlO0EEEiI6F9XNRnjirlKsAJpx++ERCjjIvi Bd+Q== X-Forwarded-Encrypted: i=1; AJvYcCXsLUZ2Qt63kokp6jnRFF+wDpBXfW9/bQwXgIiyDFU77EyXhLCjXEmHDNHir0ZTKTHdkZ6KGOlwRMP2@lists.postgresql.org X-Gm-Message-State: AOJu0YyPFI56jMCLG6T0H2oW1/XCUiG3rGqQzoDqVgaOoBxfwi/lF5hX 3fcF0auNGdFcnzZy9X9cfl8yMxC5RgMtLnTAieFfloXJbVcDw3zdo4yV X-Gm-Gg: ATEYQzygdmJtiPdVQqok4DRX/UCEedznbtbe0oYoSYDgmCDqfy8Jw0VFs2c+kXzalJE SNITqEX3vql2lFcfAcNZUj3TsI86jh4+5UQp3QhboPCGc7mItKhA5K2jSDo/Y5+ubeW2foOYytf ojSvIqKlxDJ98009h9Dl297iaV+eZH8QKt8Jen7uYEhmpbOFMnsynVjm2KhO5VGsD5LLOXDp3RB xlV5iTLmMm02MxBKGV0Xnri6bq17WtKyEWrF2VpdVnAztL5JtdNHFeaZvCUX1dYGvHgQ/2CrPiX qTPOcTHyANfkca08ZKxvUsk+Z3M98H4YuRBx1N1Lk9e4MUXTYMIWNAGfqjBusiRYC2+3ey8YNRq fxxJ2erahbFZhe+9qpGHkSQLMKbLdpxL3rF7LFOHZa2fEuYxLQKLJXlUIA1HRCJDCu1DoxjbVPN u9CAlJq1fVg3tc4bFg6VLsnjcO0WMTtxtwOa2t3FgBGzlLTI23bKKnacjGn9nuyzleA8v98PWql 5XtQcb1jqYyIsli2q3SNQ== X-Received: by 2002:a05:6830:240b:b0:7d7:cd62:6e0e with SMTP id 46e09a7af769-7d7cd6271c9mr517083a34.9.1773795036783; Tue, 17 Mar 2026 17:50:36 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-7d7c9952114sm1038711a34.3.2026.03.17.17.50.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 17 Mar 2026 17:50:35 -0700 (PDT) Date: Tue, 17 Mar 2026 19:50:33 -0500 From: Nathan Bossart To: Tom Lane Cc: Robert Haas , Peter Eisentraut , "David G. Johnston" , "Ing. Marijo Kristo" , PostgreSQL Bug List Subject: Re: Revoke Connect Privilege from Database not working Message-ID: References: <3467676.1744041977@sss.pgh.pa.us> <1933586.1768950341@sss.pgh.pa.us> <2222571.1769014621@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="m6BrJmZ21ThuEPo6" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --m6BrJmZ21ThuEPo6 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline I went ahead and tried adding docs, tests, and a commit message. The documentation for these commands might need a revamp. They seem to meander a bit, probably due to decades of organic development. But that's probably not this patch's problem. -- nathan --m6BrJmZ21ThuEPo6 Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=v3-0001-Allow-choosing-specific-grantors-via-GRANT-REVOKE.patch