Discussion on "Building Multi-Tenant APEX Apps"

Jon Dixon · 2023-06-08T13:08:40.047Z

Introduction In this post, I will describe how you can leverage the apex_session.set_tenant_id PL/SQL API and the APEX$SESSION Application Context to build Multi-Tenenat APEX Applications. Note: If you are using the Enterprise Edition of the Oracle D...

Hi! gone through the Multitenant info. if Oracle APEX give the options to create tenant and at login we can set the tenant id and in application or query from background it will tenant id default in all our query so it will be treat as low code. Share your views.

APEX has no setting to make it magically aware of your tenant. APEX must know which columns on your tables/views must be filtered. You can add = SYS_CONTEXT('APEX$SESSION,' 'APP_TENANT_ID') in your create view statements, etc., so they only show data for that tenant. See the Secured Views section of this post.

Jon Dixon Thanks for reply. I agreed your solutio but I am thinking in some other way , at the time of login we can set the tenant id then in any table or view we do not need to put the common where clause Oracle APEX automatically append or add tenant id and filter data based on the tenant ID so this will reduce the risk of missing the where clause in any table,chart, forms, reports etc.

HI, In my case, the customer have access to many companies, and he can change the company on a select menu on top navigation bar. How can I change the tenant_id without forcing the user to logout and login again? Tks!

Hi Cezar. Unfortunately, you can only call APEX_SESSION.SET_TENANT_ID once per session. It would be great if this were not a limitation but it is right now.

Search Hashnode

Building Multi-Tenant APEX Apps

Responses3