Row level security policy

From: Mark Phillips <mphillips(at)mophilly(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Row level security policy
Date: 2024-11-14 01:33:47
Message-ID: 3BA7883C-2247-4687-A764-5777EB8755EF@mophilly.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Given a database table with one policy statement FOR SELECT applied, it is necessary to apply additional policy statements for insert, update, and delete operations?

My testing indicates that this is case but I haven’t found an explanation of this requirement in the documentation.

- Mark

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2024-11-14 01:36:27 Re: Row level security policy
Previous Message Adrian Klaver 2024-11-13 20:42:23 Re: Help with restoring database from old version of PostgreSQL