Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Multi-tenant database : Multi-tenant database architecture : Multi-tenant groups
 
Multi-tenant groups
Multi-tenant groups allow multiple tenants to map to the same table partition for a multi-tenant table and therefore share the same data for that table. All data within the table partition is shared by the multiple tenants that are part of the group. Physical separation of the data by group, rather than by tenant.
Not all tenants need to participate in a multi-tenant group when a group exists on the table. A group is defined for one multi-tenant table. A tenant participating in a group for one multi-tenant table is not required to participate in a group for a different multi-tenant table. When deleting a tenant participating in a multi-tenant group, the table partition can only be deleted if it is not currently being shared by other tenants.
The following figure illustrates a multi-tenant table with a group. Tenant 1 and Tenant 2 belong to Group 1 and therefore share the same multi-tenant table partition and all data therein. Tenant 3 has its own table partition. While Tenant 1 and Tenant 2 have access to the same data, neither has access to Tenant 3's data, and Tenant 3 does not have access to Group 1's data.
Figure 45. Multi-tenant group