Super-tenant data updates
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Super-tenant data updates
ABL allows a super tenant to create (with can-create access) and update (with can-write or can-delete access, as appropriate) database records for specified tenants using the following elements:
-
CREATEstatement andBUFFER-CREATE( )method on a buffer handle — For a multi-tenant table, these ABL elements provide an option for a super tenant to create a database record for a specified tenant, regardless of the effective tenancy. Without this option, these ABL elements create database records owned by the effective tenant. -
All record update statements, such as
ASSIGN,SET,UPDATE,DELETE, etc. — Regardless of the current effective tenant, ABL remembers the tenancy of all records created in or retrieved from a multi-tenant database. When a super tenant updates database records created for multiple tenants or queried for multiple tenants, ABL ensures that all these record instances are written to or deleted from the table instances owned by the corresponding tenants.
The universal rule is that if a record in a database buffer is owned by a given tenant or tenant group, ABL writes any updates to that record only for the same tenant or tenant group, regardless of the user's effective tenancy.
Note: If data you want to change in multi-tenant tables
is updated from temp-tables, or any other internal or external data
store outside of the OpenEdge multi-tenant database, you must track
the tenancy of any data that is not maintained in database buffers.
For more information, see Identifying tenancy in temp-tables.