Popular posts

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.