Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE

Laurenz Albe <laurenz.albe@cybertec.at>

From: Laurenz Albe <laurenz.albe@cybertec.at>

To: Steve Chavez <steve@supabase.io>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2026-01-28T20:28:43Z

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