Hello
We're about to start building a new APEX application that should live in the OCI as a multi-tenant SaaS application so that users can buy a subscription to it in order to use it and manage their data independently of other users (tenants).
I've been researching and found information kind of related but focused on On-Premises APEX on local database using mechanisms such as a single PDB for every new Tenant, or one PDB with multiple Schemes (one for each Tenant), or including in every table in the database model a Security Group column and security polices along with the Database VPD (Virtual Private Database) features.
Since my App needs to live in the OCI, things like PDBs won't work.
So, for those who have already developed such kind of Apps in the cloud what approach do you consider the best considering aspects like maintainability, security, deployment, etc?
Any guidance is greatly appreciated.
Thanks in advance.
Regards
-Fernando