Mailing-List: contact users-help@isis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@isis.apache.org
MIME-Version: 1.0
In-Reply-To: <CAEHmYmSr=ykdzosGux97KwNdH=Z9EwR4CSyEz6AucP8FW1m+tA@mail.gmail.com>
References: <CAEHmYmSr=ykdzosGux97KwNdH=Z9EwR4CSyEz6AucP8FW1m+tA@mail.gmail.com>
From: Jeroen van der Wal <jeroen@stromboli.it>
Date: Wed, 18 May 2016 22:50:32 +0200
Message-ID: <CAHnP6miFfgdzvGxds91EDqTYSg_95U+1Yx6ZnP8wB+=SbT6hvQ@mail.gmail.com>
Subject: Re: Mult-Tenancy
To: users <users@isis.apache.org>
Content-Type: multipart/alternative; boundary=001a113fc2305d17800533240314
archived-at: Wed, 18 May 2016 20:51:03 -0000

--001a113fc2305d17800533240314
Content-Type: text/plain; charset=UTF-8

Hi Sunand,

Because we needed more sophistication we've gone for option 3 and not
implemented 1 and 2 but Datanucleus should be able to support those
scenarios  [1]. What use case are your trying to solve?

Cheers,

Jeroen

[1]
http://www.datanucleus.org/products/accessplatform_3_1/rdbms/multitenancy.html


On 18 May 2016 at 19:08, sunand p <sunandonline@gmail.com> wrote:

> Hi,
>
> We have Isis-Security module as an addon which provides multi-tenancy
> feature. Presently multi-tenancy as I understand is with respect to
> associating an user to a tenant and assigning roles and permissions. "*Each
> user can be associated with a particular tenancy, and Isis can then be
> configured such that they cannot access data in other tenancies*"
>
> As for data, multi-tenancy is achieved via following ways,
>
> 1) Have a separate schema per tenant and have the tables created within the
> schema and refer to it as (for example) *tenant1_schema.table1*
>
> 2) Have a separate database assigned to a tenant and keep all the data in
> that DB.
>
> 3) Store all data in one table and have a tenant id discriminator. Include
> the discriminator in the query framework after resolving a tenant add the
> where clause to each query (For example) Select * from Table1 where
> tenantId = 'tenant1'
>
> As for Apache Isis how can I support Option 1 and Option 2 in the current
> framework?
>

--001a113fc2305d17800533240314--