Re:Our Multi-Tenancy Journey with Postgres Schemas and Apart...
by chrismorgan on Tuesday December 06, 2016 @09:44AM
(#13114889)
How about row-level security? As I understand it—without having actually used it—it should be able to get the same level of isolation as schemas (so long as you stay away from incrementing, user-exposed IDs), simply making all the other tenants’ data invisible.
[ Parent
| on HN ]
Re:Our Multi-Tenancy Journey with Postgres Schemas and Apart...
by 15155 on Tuesday December 06, 2016 @12:43PM
(#13116561)
RLS doesn't allow for one very important administrative feature:
Data migration/export
Schemas allow an admin to excise an exact backup of a user's data without any other users, RLS is a little less flexible in this regard.