Re: Clarification on RLS policy

2025-04-29 Thread Vydehi Ganti
t 3:29 PM Vydehi Ganti 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/

Re: Clarification on RLS policy

2025-04-25 Thread Vydehi Ganti
Can i know if there is any scenario or ref document for the design you suggested above? On Fri, 25 Apr, 2025, 18:56 Dominique Devienne, wrote: > On Fri, Apr 25, 2025 at 3:21 PM Vydehi Ganti wrote: > > So I don't have a possibility to append where clause dynamically and can &g

Re: Clarification on RLS policy

2025-04-25 Thread Vydehi Ganti
So I don't have a possibility to append where clause dynamically and can only check the boolean? On Fri, 25 Apr, 2025, 18:48 Dominique Devienne, wrote: > On Fri, Apr 25, 2025 at 3:01 PM Vydehi Ganti wrote: > > Then it should build up the lPredicate with the filter condition and &

Re: Clarification on RLS policy

2025-04-25 Thread Vydehi Ganti
ON one.activity FOR SELECT TO one USING (one.get_country('one','activity')); On Fri, Apr 25, 2025 at 6:23 PM Dominique Devienne wrote: > On Fri, Apr 25, 2025 at 2:43 PM Laurenz Albe > wrote: > > On Fri, 2025-04-25 at 12:38 +0530, Vydehi Ganti wrote:

Clarification on RLS policy

2025-04-25 Thread Vydehi Ganti
Hi Team, We are presently using Postgresql:PostgreSQL 15.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-23), 64-bit I have a scenario where 1.I need to enforce RLS policy on a table for Select by calling a Function 2.The function would return a character varying str