MIME-Version: 1.0
References: <CAMH-PzUPN7JcLXJx-aJzGnJD2T-aSMo8gaMFkzO_x26urpMqSA@mail.gmail.com>
 <88804c921b425d37a3072b5698b558a763d80d63.camel@cybertec.at>
 <CAFCRh-_fXGfKk6b26xaDD1fg5OhLy92bNofmeDfX2TFjkQLLXA@mail.gmail.com>
 <CAMH-PzXe7AR2QDCDx3eRZPMGuixfTwm3sLF3kMZQkyNhtu=5qQ@mail.gmail.com>
 <CAFCRh-8_fXc-96mVtuW7=9CeXWW5duopnOdMVCXrbPjJ_aMD9Q@mail.gmail.com>
 <CAMH-PzW2aAC2cVGoLfKxU2dLx-_dwz+Y47zN9f8jHjTifUhT+Q@mail.gmail.com>
 <CAFCRh-9+65e25FCzGbO9W-LXX1Bcf-LYVec-F5br6ZvmcyTv1A@mail.gmail.com>
 <CAMH-PzUBLFXsNPeovtg1iLf=HqOxzgTBn+6iToPNnOY0ds9b=A@mail.gmail.com> <CAFCRh--LGkYWR9ziyAiC_ESZ1NZupDSJZm9ALDmdjezT7r26+Q@mail.gmail.com>
In-Reply-To: <CAFCRh--LGkYWR9ziyAiC_ESZ1NZupDSJZm9ALDmdjezT7r26+Q@mail.gmail.com>
From: Vydehi Ganti <rayudugs@gmail.com>
Date: Tue, 29 Apr 2025 13:35:59 +0530
Message-ID: <CAMH-PzXKwDgS3dk8VDJ8aUp859wf0-vpTevxGFaxZZzCgGzbkQ@mail.gmail.com>
Subject: Re: Clarification on RLS policy
To: Dominique Devienne <ddevienne@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000007d93d0633e64666"
Archived-At: <https://www.postgresql.org/message-id/CAMH-PzXKwDgS3dk8VDJ8aUp859wf0-vpTevxGFaxZZzCgGzbkQ%40mail.gmail.com>
Precedence: bulk

--00000000000007d93d0633e64666
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

Checking the documents .
Post fetching Boolean can we have a trigger or function which can build up
the where filter clause?
Or can i have a case statement in the Using which can return such
statements?


On Fri, Apr 25, 2025 at 7:02=E2=80=AFPM Dominique Devienne <ddevienne@gmail=
.com>
wrote:

> On Fri, Apr 25, 2025 at 3:29=E2=80=AFPM Vydehi Ganti <rayudugs@gmail.com>=
 wrote:
> > Can i know if there is any scenario or ref document for the design you
> suggested 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
>

--00000000000007d93d0633e64666
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>Checking the documents .=C2=A0</div=
><div>Post fetching Boolean can we have a trigger or function which can bui=
ld up the where filter clause?</div><div>Or can i have a case statement in =
the Using which can return such statements?</div><div><br></div><div><br></=
div></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"=
ltr" class=3D"gmail_attr">On Fri, Apr 25, 2025 at 7:02=E2=80=AFPM Dominique=
 Devienne &lt;<a href=3D"mailto:ddevienne@gmail.com">ddevienne@gmail.com</a=
>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On =
Fri, Apr 25, 2025 at 3:29=E2=80=AFPM Vydehi Ganti &lt;<a href=3D"mailto:ray=
udugs@gmail.com" target=3D"_blank">rayudugs@gmail.com</a>&gt; wrote:<br>
&gt; Can i know if there is any scenario or ref document for the design you=
 suggested above?<br>
<br>
Some docs:<br>
<a href=3D"https://www.postgresql.org/docs/current/ddl-rowsecurity.html" re=
l=3D"noreferrer" target=3D"_blank">https://www.postgresql.org/docs/current/=
ddl-rowsecurity.html</a><br>
<a href=3D"https://satoricyber.com/postgres-security/postgres-row-level-sec=
urity/" rel=3D"noreferrer" target=3D"_blank">https://satoricyber.com/postgr=
es-security/postgres-row-level-security/</a><br>
<br>
Your Oracle function converted to PostgreSQL, FWIW. Use at your own risk.<b=
r>
<a href=3D"https://chatgpt.com/share/680b8e36-b4ac-800e-9e0e-2601aecd2aee" =
rel=3D"noreferrer" target=3D"_blank">https://chatgpt.com/share/680b8e36-b4a=
c-800e-9e0e-2601aecd2aee</a><br>
</blockquote></div>

--00000000000007d93d0633e64666--