Re: PostgreSQL

Поиск
Список
Период
Сортировка
От Joseph Kennedy
Тема Re: PostgreSQL
Дата
Msg-id 8C7CE513-7187-428E-81C2-508C85812B54@gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: PostgreSQL  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: ERROR: deadlock detected
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Sequence vs UUID