Skip to Main Content
Feature Request FR-3161
Product Area Developer Experience
Status CLOSED

3 Voters

Tenant_ID, Implementation

yannis_r Public · May 23 2023

Idea Summary
You have the option to create the Tenant_ID field in every column. Fantastic!

When it is selected, you can create the tenant base table. and use an Application Item called Tenant_ID (that the developer must go and create) then in all the triggers BIU you can insert the proper line to fill the field.

Use Case
You unleash the SaaS option to the community

Preferred Solution (Optional)
Through Quick SQL, which is a fantastic tool that took development many-many levels ahead!

Then you can create a new app and add it in https://apex.oracle.com/en/learn/tutorials/ showing exactly how to create a multi-tenant application.

This idea has been closed due to the lack of community activity during the period since it was submitted.

Comments

Comments

  • shyamngr OP 2.4 years ago

    Tenant_id is good option in every table.

    only need to include tenant_id in Oracle APEX system roles, Menu and Lists so that it will be easy and complete solution whiteout writing more code (use Low Code in true). 

    In user also it must include but at present i am using attribute field to store and filter for the same.

    Hope Oracle APEX developer team can include and make developer task easy.

  • yannis OP 2 years ago

    A manual solution is described in the article: Building Multi-Tenant Applications with Oracle APEX (cloudnueva.com)