Request a Demo
Home   >   mailing lists

Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE
Date
Msg-id 8e50f0589c3a40cdec7b05bd4220dd4680c3237d.camel@cybertec.at
Whole thread Raw
In response to Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE  (Steve Chavez <steve@supabase.io>)
Responses Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE
List pgsql-hackers
Tree view 
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'tthey 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

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE
Next
From: Viktor Holmberg
Date:
Subject: Re: ON CONFLICT DO SELECT (take 3)