Issue Details (XML | Word | Printable)

Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Andy Jefferson
Votes: 0
Watchers: 0

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

Sort Order: Ascending order - Click to sort in descending order
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
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