Issue Details (XML | Word | Printable)

Key: NUCRDBMS-555
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Support "multi-tenancy"/"multi-user" via discriminator

Created: 31/Aug/11 05:47 PM   Updated: 03/Oct/11 07:38 AM   Resolved: 06/Sep/11 11:13 AM
Component/s: Schema
Affects Version/s: None
Fix Version/s: 3.0.2


 Description  « Hide
JDO (and JPA) allows multi-tenancy using separate schema for each "tenant". We could alternately support it via a discriminator column on all tables, so any INSERTs/UPDATEs/DELETEs will pass in the tenant id, and any SELECTs will add the tenant restriction in the WHERE clause

Andy Jefferson added a comment - 06/Sep/11 11:13 AM
SVN trunk now has initial support for multi-tenancy for RDBMS. Specify persistence property
datanucleus.tenantId
to the name of the tenant for this application instance and a discriminator column "TENANT_ID" will be added to all persistable class tables (not join tables).

Can't currently configure the column name ("TENANT_ID"), or type of tenant id (always String) - raise separate JIRA for those

Andy Jefferson made changes - 06/Sep/11 11:13 AM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0.2 [ 11310 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 03/Oct/11 07:38 AM
Status Resolved [ 5 ] Closed [ 6 ]