Re: RLS and Table Inheritance

2024-09-12 Thread Tom Lane
Sanjay Minni 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

RLS and Table Inheritance

2024-09-12 Thread Sanjay Minni
Hi, 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 inherite