QuickSQL additional VIEW configuration to accommodate Tenant_ID

[pallasinfotech]

To create quickly secure views for multi-tenant applications, allow a switch line

Example:

view Knowledge_articles_v Knowledge_articles /where tenant_id = SYS_CONTEXT('APEX$SESSION', 'APP_TENANT_ID');

after "/where" the user can add his portion of where statement that can be utilized in the creation of a secure view.

Use Case Multi-tenant applications require all tables to be accessed through secure views. Having where statement ready with the argument, will make the development of the script tremendously easier and accurate.