Re: PostgreSQL - Mailing list pgsql-general

From Laurenz Albe
Subject Re: PostgreSQL
Date
Msg-id dabd6f968361f363f2ecb93a7be2bc27ddd68908.camel@cybertec.at
Whole thread Raw
In response to PostgreSQL  (Joseph Kennedy <joseph.kennedy.486@gmail.com>)
Responses Re: PostgreSQL  (Joseph Kennedy <joseph.kennedy.486@gmail.com>)
List pgsql-general
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: Philip Semanchuk
Date:
Subject: Re: ALTER COLUMN to change GENERATED ALWAYS AS expression?
Next
From: Laurenz Albe
Date:
Subject: Re: ERROR: deadlock detected