Re: Clarification on RLS policy

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: Vydehi Ganti <rayudugs(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Clarification on RLS policy
Date: 2025-04-25 13:17:48
Message-ID: CAFCRh-8_fXc-96mVtuW7=9CeXWW5duopnOdMVCXrbPjJ_aMD9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 25, 2025 at 3:01 PM Vydehi Ganti <rayudugs(at)gmail(dot)com> wrote:
> Then it should build up the lPredicate with the filter condition and append to the query user runs on the Activity table.

You're not reading us, and asking us to do the work for you...
RLS Predicates don't return strings in PostgreSQL, but a boolean.
Write your function to do your check, and return TRUE or FALSE.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vydehi Ganti 2025-04-25 13:20:46 Re: Clarification on RLS policy
Previous Message Vydehi Ganti 2025-04-25 13:01:00 Re: Clarification on RLS policy