Re: Clarification on RLS policy

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Vydehi Ganti <[email protected]>
To: Dominique Devienne <[email protected]>
Cc: Laurenz Albe <[email protected]>
Cc: [email protected]
Subject: Re: Clarification on RLS policy
Date: Tue, 29 Apr 2025 13:35:59 +0530
Message-ID: <CAMH-PzXKwDgS3dk8VDJ8aUp859wf0-vpTevxGFaxZZzCgGzbkQ@mail.gmail.com> (raw)
In-Reply-To: <CAFCRh--LGkYWR9ziyAiC_ESZ1NZupDSJZm9ALDmdjezT7r26+Q@mail.gmail.com>
References: <CAMH-PzUPN7JcLXJx-aJzGnJD2T-aSMo8gaMFkzO_x26urpMqSA@mail.gmail.com>
	<[email protected]>
	<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>

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 PM Dominique Devienne <[email protected]>
wrote:

> On Fri, Apr 25, 2025 at 3:29 PM Vydehi Ganti <[email protected]> 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
>

view thread (10+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Clarification on RLS policy
  In-Reply-To: <CAMH-PzXKwDgS3dk8VDJ8aUp859wf0-vpTevxGFaxZZzCgGzbkQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox