Re: PostgreSQL - Mailing list pgsql-general

From Joseph Kennedy
Subject Re: PostgreSQL
Date
Msg-id 8C7CE513-7187-428E-81C2-508C85812B54@gmail.com
Whole thread Raw
In response to Re: PostgreSQL  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: PostgreSQL  (Stephen Frost <sfrost@snowman.net>)
List 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



pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: ERROR: deadlock detected
Next
From: Merlin Moncure
Date:
Subject: Re: Sequence vs UUID