Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and ABL : ABL Support : Coding for super-tenant access : Super-tenant effective tenant
Super-tenant effective tenant
A super tenant can change effective tenancy for a given database connection with the ABL built-in function, SET-EFFECTIVE-TENANT. This function allows the super tenant to implicitly query data for the effective tenant without having to set a new user identity for the connection. All queries with this effective tenancy return only shared data and data owned by the effective tenant.
Once a super tenant has set an effective tenancy, the super tenant has all the same behaviors and access as the regular tenant for actions such as creating, updating, and deleting data.