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 1u8JA2-000hWC-0X for pgsql-general@arkaria.postgresql.org; Fri, 25 Apr 2025 13:32:10 +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 1u8JA0-00BBTa-9P for pgsql-general@arkaria.postgresql.org; Fri, 25 Apr 2025 13:32:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u8J9z-00BBTQ-Tm for pgsql-general@lists.postgresql.org; Fri, 25 Apr 2025 13:32:08 +0000 Received: from mail-oo1-xc34.google.com ([2607:f8b0:4864:20::c34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u8J9y-001tav-1t for pgsql-general@lists.postgresql.org; Fri, 25 Apr 2025 13:32:07 +0000 Received: by mail-oo1-xc34.google.com with SMTP id 006d021491bc7-6042c04fd18so1295695eaf.2 for ; Fri, 25 Apr 2025 06:32:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745587926; x=1746192726; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=JMAXRZRnknLQ2BS2aIS7RXa3p1nxMzWDdILf+a33sYk=; b=DnFbxpzVLvviC0lx6jI5RMkISAE+9SeZOSkaLOZckg3zVuovf0dug7TfTUXKG5iumt 4qwAgaRsIf1fhJU8rB4q8cIIuN/f7ikCnMYe4OK3VFjR2tzKUnyiy0Ned4qQPOdJLoke W+s0N6M0yzI8ADWx8LhOy2WFMrzzq6V5221fHsMDqUJsleV1ofSOuDhVxeRwiGcP6uuG WsF5PYpZXiANi1oiqoNQ/WUgGwUFGRyL157l/iOiMswjG4clxc8EN5DfW+4fXYuQ1t/T SkFHFJ1JfOUYrzPAym0rBFIcHpf+y2iGO+5+BoL2L8OTge9yg6R7HNfPvUF80PyoxTwj A0KA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745587926; x=1746192726; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=JMAXRZRnknLQ2BS2aIS7RXa3p1nxMzWDdILf+a33sYk=; b=IurFyOWRni0jCuMAlIigQJ+mSSDbjic1FrUUA/9H6OqyojccHeKCvW7eswP3tp8gP5 2FSvpj44GHp5++FMRvpRlnPvF8K8GiwJUb0lvHY++8hwqO08Y9EXTG3CFRjVRRGpq4/Q /jXOYfK5BO5WmdOFfka9piFHyxEvmCkYyu6A9Jj3TwfJODVs8xjVlvnRxMrDVuYMpBh0 L5QXWgYX/xR7E5yuMPqJ55pRDD2uZTJ3FbKpzG2Vxze5xkbZGZana1dTHyoKYOaqGFTA qpDaZ3+G4E9gF5GxnHzMUYvfgphFHGbbSHZ/d/9oLU1xM4gSoH0rkRmzwQs95tsL+reg Qj6A== X-Forwarded-Encrypted: i=1; AJvYcCVwcLP7VK61jcrTaY1NBO401vw1lXtroZEVQh/2E6q28Hg7NhdpuVva7llvCUym0GKr4E9vE1ewyIQC0ODS@lists.postgresql.org X-Gm-Message-State: AOJu0YzNvcdmVX/q9N5lwjC93Aw3uXYU2fJy2Xlom4fcRQaUN0M7WrRM B+qAH2Mx+kpvesrC7jfhV6xozfBphSt1pISbfCQpJZshLhiTXjclfMfOeTpVBdRzS1U8CVyRM6z jnki49NWL+0zjA79ysUVrAFeYLnc= X-Gm-Gg: ASbGncvRKASDZKKNyjLYdOp6f0F8GUPK1KC696EPK0KsCPuS/VuDh6Lvf8pCoW9e9rp seRmoYb8MOpyan6XC6DSUGCWWd5kh7FtZyLXC0cGmFEOToh3zwO4IRCC6hM92ytZ7B+TinAusnC 4DF5hqDeABkA5g594mAm0M10jC X-Google-Smtp-Source: AGHT+IE7PKgv0OHo73W3IwuOwJqE74fSoqBoFD46ubjuwRGt9piU73ozw5jpcH109GJxVpoJNMfudumnZd82qcD/Ghs= X-Received: by 2002:a05:6820:2982:b0:604:ae66:1e86 with SMTP id 006d021491bc7-606527a1079mr1118430eaf.0.1745587926465; Fri, 25 Apr 2025 06:32:06 -0700 (PDT) MIME-Version: 1.0 References: <88804c921b425d37a3072b5698b558a763d80d63.camel@cybertec.at> In-Reply-To: From: Dominique Devienne Date: Fri, 25 Apr 2025 15:31:32 +0200 X-Gm-Features: ATxdqUErEn7tOLoVB1xs89u9QFszEU4ldx6LpiB_hGTwOnzJM3EuriSQWZjjwGE Message-ID: Subject: Re: Clarification on RLS policy To: Vydehi Ganti Cc: Laurenz Albe , pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Apr 25, 2025 at 3:29=E2=80=AFPM Vydehi Ganti w= rote: > Can i know if there is any scenario or ref document for the design you su= ggested above? Some docs: https://www.postgresql.org/docs/current/ddl-rowsecurity.html https://satoricyber.com/postgres-security/postgres-row-level-security/ Your Oracle function converted to PostgreSQL, FWIW. Use at your own risk. https://chatgpt.com/share/680b8e36-b4ac-800e-9e0e-2601aecd2aee