Re: Can row level security policies also be implemented for views?

From: Caleb Meredith <calebmeredith8(at)gmail(dot)com>
To: Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can row level security policies also be implemented for views?
Date: 2015-12-03 13:17:19
Message-ID: CABFpK631z6nnK2wuPsLZH7zGNsWx7bNLFG45KbW2DNiTVD_96Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes it probably could be solved by this. Just a trigger which replaces
SELECT right?
On Wed, Dec 2, 2015 at 6:01 PM Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com> wrote:

> On 12/2/15 4:59 PM, Caleb Meredith wrote:
> > What is an SRF?
>
> Set returning function.
>
> CREATE FUNCTION srf() RETURNS SETOF pg_class LANGUAGE sql AS 'SELECT *
> FROM pg_class';
> --
> Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
> Experts in Analytics, Data Architecture and PostgreSQL
> Data in Trouble? Get it in Treble! http://BlueTreble.com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2015-12-03 14:25:53 Re: json indexing and data types
Previous Message Nguyễn Trần Quốc Vinh 2015-12-03 10:40:57 Re: fast refresh materialized view