Multitenancy is a feature of database security that enables the ability to serve multiple organizational clients, a.k.a. tenants, from a single instance of a web application. Multitenancy reduces deployment overhead by allowing multiple customers to share infrastructure while keeping tenant data segmented.
There are multiple ways to provide multitenancy. The WaveMaker implementation uses the data access layers of the WaveMaker runtime to isolate all data access by the tenant ID stored in a tentant ID column in the user's login table entry.
To use the multitenancy feature, each database table that is to be restricted by tenant ID must have an integer type column for the tenant ID. All tenant column names must be exactly the same throughout the database schema. The tenant ID column name is specified in the database security configuration panel as the Tenant ID Field Name:
With this enabled, WaveMaker will restrict all database access operations with a where tenanted = ? clause...