Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy documentation map : Additional multi-tenant information : Table types

Table types

In a multi-tenant database there are two types of tables, shared tables and multi-tenant tables:
*Shared tables — define tables that are not multi-tenant. Every non-multi-tenant table is accessible to 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 version of data and 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 mark a table to be multi-tenant. Data for multi-tenant tables is stored in partitions. Each tenant, including the default tenant, can optionally have a private data partition for each multi-tenant table.