Hello community,
I'm working with Oracle APEX 24.2.6 and have a question related to configuring instance-level authentication, specifically when using SAML as the authentication scheme.
According to the official Oracle documentation, it states that it is possible to define PL/SQL procedures for Pre-Authentication and Post-Authentication in the instance authentication scheme, even when using SAML. However, when editing the scheme from "Manage Instance → Security → Authentication Control", I don't see any options to add PL/SQL code or associate existing procedures.
What am I trying to do?
My goal is that, when a user authenticates via SAML:
- If the user doesn't already exist in the database, it will be created automatically.
- It will be automatically assigned to a specific workspace, based on custom logic.
This requires the ability to execute a Post-Authentication procedure, but that functionality doesn't seem to be exposed in the interface, despite the documentation indicating otherwise.
Questions I have
- Has anyone managed to implement Pre-/Post-Authentication Procedures in the instance authentication scheme (not at the app level) in APEX 24.2?
- Has this been removed in recent releases, or is it configured in some other way that I'm not able to understand?
- Is there a recommended alternative to executing custom post-login logic in the instance context?