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 1tBOkG-003Zjv-7l for pgsql-general@arkaria.postgresql.org; Thu, 14 Nov 2024 01:34:03 +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 1tBOkC-000679-H2 for pgsql-general@arkaria.postgresql.org; Thu, 14 Nov 2024 01:34:01 +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 1tBOkC-000671-4U for pgsql-general@lists.postgresql.org; Thu, 14 Nov 2024 01:34:00 +0000 Received: from narocalifornia.org ([206.214.166.96] helo=mophilly.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tBOk9-001o8p-6X for pgsql-general@lists.postgresql.org; Thu, 14 Nov 2024 01:34:00 +0000 Received: (qmail 25138 invoked by uid 453); 14 Nov 2024 01:33:54 -0000 X-Virus-Checked: by ClamAV 0.103.11 on mophilly.com X-Virus-Found: No Authentication-Results: mophilly.com; auth=pass (plain) smtp.auth=mphillips Received: from wsip-98-173-51-151.sd.sd.cox.net (HELO smtpclient.apple) (98.173.51.151) by mophilly.com (qpsmtpd/0.96) with ESMTPSA (ECDHE-RSA-AES256-GCM-SHA384 encrypted); Wed, 13 Nov 2024 17:33:54 -0800 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed; d=mophilly.com; h=content-type:content-transfer-encoding:from:mime-version:date:subject:message-id:to; s=default; bh=fTbVvCvRMWvFCLqw1qdgdS9Yahkq8kl3oLfo3rjVh/8=; b=OaGqAhWX3LlwugktvzSZAYFTPq0WkbwJjjymB7hNBVakLnJlyc8274PP7ZnqUs2X+QMCLbZQFfRRNHENcXV2b8Lw9WeDkPPt6L55hKgbSuznQgvE86cTRnwoaEI+5Y4EDDdXqg+mhIkw0B0aqxSpOoCimwevJAT3YRRgM+iePaaRghGFXGGvixNUoI+tn694QI9NWetulLa0MTbgiwsU6iN+ZxMepzKX1+tdX8XAiYbkuGDs2cXsTaX0lsz68DC17Fbi3j2bwX4xNkBmlkPZZ15PRvpqcdLihxWsP4ioYLthT8BfKfhxcpe3y0EwMzhpoqdjxWa2DrX6QOCAWOSIZA== Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Mark Phillips Mime-Version: 1.0 (1.0) Date: Wed, 13 Nov 2024 17:33:47 -0800 Subject: Row level security policy Message-Id: <3BA7883C-2247-4687-A764-5777EB8755EF@mophilly.com> To: pgsql-general@lists.postgresql.org X-Mailer: iPad Mail (22A3370) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Given a database table with one policy statement FOR SELECT applied, it is n= ecessary to apply additional policy statements for insert, update, and delet= e operations? My testing indicates that this is case but I haven=E2=80=99t found an explan= ation of this requirement in the documentation. - Mark=