Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mnmUX-0007Qq-QY for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Nov 2021 18:50:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mnmUW-00015v-Ii for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Nov 2021 18:50:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mnmUW-00015m-8p for pgsql-hackers@lists.postgresql.org; Thu, 18 Nov 2021 18:50:36 +0000 Received: from mail-pl1-x636.google.com ([2607:f8b0:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mnmUU-0006IK-6d for pgsql-hackers@postgresql.org; Thu, 18 Nov 2021 18:50:35 +0000 Received: by mail-pl1-x636.google.com with SMTP id v19so6041627plo.7 for ; Thu, 18 Nov 2021 10:50:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:cc:date:in-reply-to:references :mime-version:content-transfer-encoding; bh=AHmjT19Cq3+rPdg05nWzbwbh1aMtldcE+/QzXJWkfoo=; b=JUDiApVm1+tLvo656TZaDJ4SRh3MkFG8giBcYMF3dA58U6db7FUBvweTYuKAYwmVdY hGdl5zimwph/3nKy2tXtyjeqnw1FaW3Hxvgk3Mt4op832ZLL/9Tx3vbxQsWF/jVZTGdZ Y3csLQ0Qfvbo05fHvhaET2IvNl1kDAqnxJGmGCmq3fJBpA6UGjX4To+LCEczTjVG+4LY /hi09UtA4Z9yDVvfMaRGxLOBOGIiCVRQOaT+knZyOwjcPgUVBweQHtLglsSBKT744MI/ krWmOF2LKXWMcn6A21lSyj2PjWsrI+jrcV4qIhF3chFPTbT08ynuv1WJRfw4a4Ad3mzl Kw8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:cc:date:in-reply-to :references:mime-version:content-transfer-encoding; bh=AHmjT19Cq3+rPdg05nWzbwbh1aMtldcE+/QzXJWkfoo=; b=HPZABLMMwZ6bEnjMq0tccyRcgyEnnquhjIOqz+E57szlmBwlCkS5pUqxs380Ef/n/Y 2oYM/pRC+JF6xbK2yPg5iaMUVvHAnh+guO3jJg94M+vRm8Q1TfvZAAd8ZVvr15xsoS/F OBPsjvCxVoi6n7U+SaVV/c5zF1Q2p9cqwwFFXkk0v2IqAZv+/1V2Y0VhH93B+15I4bbV GvpeCf/ZxKDk48ziTLxG0RihnM/bSW/acFJ8A/zILAN4nVocY7wFJaoTd4i/TDFyhFvq qZGZSDz+u+4ZPFbl5UzE7BgeR8ZcY2issCOY+lcpJoDpiCZek4TflR+aYLtvZZpGpfVB R/iQ== X-Gm-Message-State: AOAM530D+WOe0dPn+JpNf5G+H/tEzSj5i0kypWyOsF/RLaMcaSG4v1iO IJaOhguIGhhNyNCwU1KxmS5nKA== X-Google-Smtp-Source: ABdhPJzVjzgCdC9QsxL9M02syAlS68eMae47q1VARQUjlWOrVRgsX0vCaDxB812VaHYTUccgD0+8zQ== X-Received: by 2002:a17:902:c20d:b0:142:21e:b1e8 with SMTP id 13-20020a170902c20d00b00142021eb1e8mr67780071pll.27.1637261431786; Thu, 18 Nov 2021 10:50:31 -0800 (PST) Received: from jdavis.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id f19sm325244pfc.122.2021.11.18.10.50.30 (version=TLS1_2 cipher=ECDHE-ECDSA-CHACHA20-POLY1305 bits=256/256); Thu, 18 Nov 2021 10:50:31 -0800 (PST) Message-ID: Subject: Re: Non-superuser subscription owners From: Jeff Davis To: Mark Dilger Cc: Andrew Dunstan , PostgreSQL-development , Robert Haas Date: Thu, 18 Nov 2021 10:50:29 -0800 In-Reply-To: <2EA8302B-9805-4FAA-A95D-C4D5CEB82916@enterprisedb.com> References: <9DFC88D3-1300-4DE8-ACBC-4CEF84399A53@enterprisedb.com> <6BB4451E-7B1B-474C-BD1F-DB7531E720C6@enterprisedb.com> <6A2B0FF6-CC86-48CE-B0D3-5401AA5CFEA9@enterprisedb.com> <0774acfb4e613b9959c4e4995ba163cdadc454ef.camel@j-davis.com> <2EA8302B-9805-4FAA-A95D-C4D5CEB82916@enterprisedb.com> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.28.5-0ubuntu0.18.04.2 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2021-11-17 at 16:17 -0800, Mark Dilger wrote: > Some of what I perceive as the screwiness of your argument I must > admin is not your fault. The properties of subscriptions are defined > in ways that don't make sense to me. It would be far more sensible > if connection strings were objects in their own right, and you could > grant USAGE on a connection string to a role, We sort of have that with CREATE SERVER, in fact dblink can use a server instead of a string. Regards, Jeff Davis