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.

After 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.