I am testing Multitenant feature in 12c and in my multi-tenancy use case, a user can belong to more than one tenant. This is not a Oracle admin/local/common user, but a user in the application itself, existing in its own table.
So, here are the sequence of steps:
- user logs in using userId and password
- If user belongs to more than one tenant, ask which tenant he wants to work with now. Now change the PDB.
- If user belongs to only one tenant, switch to that PDB.
Question: Since I need the user info before getting into a PDB, can I create tables at container level? How would I do this? Or, do I need to have a separate PDB just for this?