Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Multi-tenant database : Multi-tenant database architecture : Simple tenancy
 
Simple tenancy
Multi-tenant tables have a 1-to-1 relationship between a tenant and a table partition. The following figure illustrates a multi-tenant table with one schema definition, and 3 tenants in addition to a default partition.
Figure 44. Simple tenancy example
The figure above illustrates that each tenant has its own table partition to maintain its data in. Each tenant can only see data associated with its own table partition. The super-tenant has access to all the table partitions of a multi-tenant table. When a tenant is deleted, its table partition is deleted.