All data in a multi-tenant database is allocated according to the following tenant access protocol:

  • Shared (non-tenant) data — Accessible to all users, regardless of tenancy
  • Default tenant data — Accessible to default-tenant users and to super-tenant users with the default effective tenancy (the OpenEdge default setting for super tenant effective tenancy)
  • Regular tenant data — Accessible to regular-tenant users with the same regular tenancy and to super-tenant users with the same effective regular tenancy.

Regardless of tenancy, a user can only access data according to the SQL or ABL authorization settings for table and fields that have been established for their user ID in the database.