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