Re: PostgreSQL
Joseph Kennedy <joseph.kennedy.486@gmail.com>
From: Joseph Kennedy <joseph.kennedy.486@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Giovanni Biscontini <biscontini.g@es2000.it>,
pgsql-general@postgresql.org
Date: 2023-02-07T14:46:39Z
Lists: pgsql-general
Thank you Laurenz, I just wanted to make sure. Do you know any alternative solution to RLS ? > Wiadomość napisana przez Laurenz Albe <laurenz.albe@cybertec.at> w dniu 07.02.2023, o godz. 15:34: > > On Tue, 2023-02-07 at 12:36 +0100, Joseph Kennedy wrote: >> RLS policy it only affects to command as SELECT, INSERT, UPDATE, DELETE or >> can affects to operations on whole database, table like vacuum or reindex etc ? > > No, that wouldn't make any sense. Row Level Security determines who > is allowed to see or create which data. Jobs like removing dead tuples > or rebuilding an index have nothing to do with that. > > Besides, anything that requires the table owner or a superuser cannot > be reasonably controlled with row level security, because both the > table owner and a superuser are exempt from RLS anyway. > > Yours, > Laurenz Albe