APEX 19.1 on 2 x Oracle 12.1 databases. ORDS on Tomcat as web server.
Requirements:
Custom authentication of user against LDAP server (user type 1) or AD servers (user type 2).
Custom SSO support, with a single Master APEX app doing the authentication, with Partner APEX apps supporting/using authenticated Master App session, without having to self authenticate.
And to make this slightly more complex, Master app with a number of Partner apps will be on database 1, with a couple of Partner apps on database 2. Web URL will however have the same base (e.g. web-server/ords), for both database 1 (e.g. web-server/ords/db1), and database 2 (e.g. web-server/ords/db2).
The LDAP and AD authentication are fairly easily done (been there, and done similar). And with databases 1 & 2 on the same subnet, db links to/from both exist.
The main question is how to best make a Partner App trust, and use, the credentials and authenticated Master App session. Will appreciate comments, recommendations , doc references, and URL pointers, on how to best address these requirements.
Thanks!