Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Introducing multi-tenancy : How does data access work? : Table types

Table types

A multi-tenant database can contain the following two types of tables:
*Shared tables — Define tables that are not multi-tenant. Every non-multi-tenant table is accessible by all users, regardless of tenancy. Shared tables are just like the tables in all OpenEdge databases prior to OpenEdge 11, and defined data access privileges on shared tables still apply.
*Multi-tenant tables — Define tables where each tenant has its own set of data. Regular tenant users cannot access the data of other tenants. Multi-tenant tables are accessible only to users in domains defined for a given tenant and by super tenants.
For a table to be multi-tenant, a database administrator has to enable multi-tenancy for the table either through the Data Dictionary or the Database Administration Console. Data for multi-tenant tables is stored in partitions. Each tenant, including the default tenant, can optionally have a the data partition for each multi-tenant table allocated or not.
* Multi-tenant objects
* Object allocation
* Allocation states
* Multi-tenant table instance
* Data partitions
* Default storage area
* Multi-tenant sequences