Re: PostgreSQL - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: PostgreSQL
Date
Msg-id 20230207214230.cvyo3ynsoegytnxh@hjp.at
Whole thread Raw
In response to Re: PostgreSQL  (Giovanni Biscontini <biscontini.g@es2000.it>)
List pgsql-general
On 2023-02-07 12:36:57 +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 ?

"Row level security" works, as the name implies at the row level.
Tables, schemas and databases and covered by the "usual" SQL privilege
system.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: ALTER COLUMN to change GENERATED ALWAYS AS expression?
Next
From: "sunyucong@gmail.com"
Date:
Subject: Need help debugging slow logical replication