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 1npOwe-0006Zp-Q0 for pgsql-hackers@arkaria.postgresql.org; Fri, 13 May 2022 06:38:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1npOwd-0004rn-LK for pgsql-hackers@arkaria.postgresql.org; Fri, 13 May 2022 06:38:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1npOwd-0004rP-CP for pgsql-hackers@lists.postgresql.org; Fri, 13 May 2022 06:38:35 +0000 Received: from mail-ed1-x530.google.com ([2a00:1450:4864:20::530]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1npOwa-0004zy-T4 for pgsql-hackers@lists.postgresql.org; Fri, 13 May 2022 06:38:34 +0000 Received: by mail-ed1-x530.google.com with SMTP id be20so8726074edb.12 for ; Thu, 12 May 2022 23:38:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=from:to:cc:subject:in-reply-to:references:comments:mime-version :content-id:content-transfer-encoding:date:message-id; bh=3Tub2x5qJSuIKMh2nKC9rJuA5/+47/ICD6NYFdRWG1I=; b=6/QJhfHY76vjETnDGCbuWXv4V5wPJmYXWveMhmbi4+aZrqZB+WSMJyI8wBv1APpXD7 8gyf3RW5kWy3jFj3lFYp22DImkKyC7txweBBGMznT5V+DcoWVvHpQUVBnqfrvdyab0Xa uwCeOrr/aOJDzqj+Ic0ZdP2PzvvxSx/stG8uZ1o5tmAvhzyetI1tQwQyg98/FgoP1gn0 DhibQYkZqmGo45PFUML5ghOhXqX+OUxoHCGR49OGG2NMqooXMvev6s/FT8Tj+WiIlQZz TKTQNkGNllGh4gn8peW2a2JuNQEhDVtfGmBp2xujDYQN/h7hLDNXNRwBGwOmP9IHVAg0 Ignw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:cc:subject:in-reply-to:references :comments:mime-version:content-id:content-transfer-encoding:date :message-id; bh=3Tub2x5qJSuIKMh2nKC9rJuA5/+47/ICD6NYFdRWG1I=; b=uNGUlbDeebUTTq2/ulqnQbuQV9a4fB4rWU84XzzYYSHTFQH84M5HLNZurHolIKrxEu ko4ELcA1giCREJfII6PuOeDGVFIy7d6FpO/OqUeoW1TXrx2ri4cNxCOlLhvp4CQCB6dt Ngd5dMZKRLciWcs1wt2m2kYPuJb+TH61k3uZpIoW1L9No93mIRPYRXI4fy2uSxwzXF6P emyNTH99P4JFocDSdOmGqQcDVUa/eGNj4EGdey5QKVSaNhOlvXnhO4C10wUmPYpYbjiM qzug0CFddEzJTe+8Ag7DLHExgb08XEtgNX6UjCPMjun+9Ok2jYyF4R9GxC3hNQ1kCoIe IhNQ== X-Gm-Message-State: AOAM533FOQb5eJAB+UqbIR3i+9RxsNP75I3PRcS8njAne8PJiivXdt76 CCphcnS470+WK3WhqKRDcdmnxQ== X-Google-Smtp-Source: ABdhPJydTnCDMCgM2ohXGaFuw1PRch6gR4tPXV4la0CybB9uc57oHNeZHw/ysmt+pShjg/yIJFHzhg== X-Received: by 2002:a05:6402:3552:b0:427:e36a:e839 with SMTP id f18-20020a056402355200b00427e36ae839mr38152957edd.351.1652423911644; Thu, 12 May 2022 23:38:31 -0700 (PDT) Received: from antos (85-207-121-76.static.bluetone.cz. [85.207.121.76]) by smtp.gmail.com with ESMTPSA id p7-20020a17090664c700b006f3ef214de3sm447060ejn.73.2022.05.12.23.38.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 May 2022 23:38:31 -0700 (PDT) From: Antonin Houska To: Peter Eisentraut cc: Amit Kapila , Euler Taveira , PostgreSQL Hackers Subject: Re: Privileges on PUBLICATION In-reply-to: References: <20330.1652105397@antos> <8a00e0e1-dc4e-422c-9dcf-664b16b18625@www.fastmail.com> <2810.1652171844@antos> Comments: In-reply-to Peter Eisentraut message dated "Thu, 12 May 2022 07:46:56 +0200." X-Mailer: MH-E 8.6+git; nmh 1.7+dev; GNU Emacs 27.2.50 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <5868.1652423935.1@antos> Content-Transfer-Encoding: quoted-printable Date: Fri, 13 May 2022 08:38:55 +0200 Message-ID: <5869.1652423935@antos> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Peter Eisentraut wrote: > On 10.05.22 10:37, Antonin Houska wrote: > > My understanding is that the rows/columns filtering is a way for the > > *publisher* to control which data is available to particular replica.= From > > this point of view, the publication privileges would just make the con= trol > > complete. > = > I think privileges on publications would eventually be useful. But are = you > arguing that we need them for PG15 to make the new features usable safel= y? I didn't think that far, but user should be aware of the problem. My propo= sal of documentation is in https://www.postgresql.org/message-id/5859.16524237= 97%40antos -- = Antonin Houska Web: https://www.cybertec-postgresql.com