Re: RLS and Table Inheritance - Mailing list pgsql-general

From Tom Lane
Subject Re: RLS and Table Inheritance
Date
Msg-id 4016747.1726150788@sss.pgh.pa.us
Whole thread Raw
In response to RLS and Table Inheritance  (Sanjay Minni <sanjay.minni@gmail.com>)
List pgsql-general
Sanjay Minni <sanjay.minni@gmail.com> writes:
> Do RLS policies defined at the parent, work on the child (in Table
> inheritance).
> At the parent I have a column 'site_id' with an RLS policy that only rows
> with site_id = current_setting(curr_site_id) would be accessible.
> However the policy defined at the parent does not work for me in inherited
> tables. Is it intended that way ?

If you mean when accessing the child tables directly, yes.

            regards, tom lane



pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC
Next
From: Durgamahesh Manne
Date:
Subject: Re: Performance degrade on insert on conflict do nothing