Re: Multi-tenancy with RLS - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Multi-tenancy with RLS
Date
Msg-id 20150915200052.GZ3685@tamriel.snowman.net
Whole thread Raw
In response to Re: Multi-tenancy with RLS  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> On Tue, Sep 15, 2015 at 9:18 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
> > Also, we've faced issues in the past with making catalog changes due to fear
> > of breaking user scripts. Instead of doubling down on that with RLS on top
> > of catalog tables, would it be better to move the tables to a different
> > schema, make them accessible only to superusers and put views in pg_catalog?
>
> Uggh.  -1 on that option from me.

Yeah, -1 from here too...  That way leads to madness (note that we still
haven't managed to get rid of the pg_user, et al,
backwards-compatibility views from, uh, 8.2?).

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Multi-tenancy with RLS
Next
From: Jeff Janes
Date:
Subject: Re: Summary of plans to avoid the annoyance of Freezing