Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Steve Chavez <steve(at)supabase(dot)io>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE
Date: 2026-01-28 20:28:43
Message-ID: 8e50f0589c3a40cdec7b05bd4220dd4680c3237d.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2026-01-28 at 14:19 -0500, Steve Chavez wrote:
> CMIIW, but wasn't security_barrier a mechanism to do RLS before actual RLS (policies) were introduced? So in a way aren't they superseded by RLS?

I wouldn't say so.

Creating a view that allows a user to see only certain columns of a table
is something quite different from restricting the rows a user can operate on.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Viktor Holmberg 2026-01-28 20:33:21 Re: ON CONFLICT DO SELECT (take 3)
Previous Message David G. Johnston 2026-01-28 19:39:18 Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE