Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX with Database Authentication and Custom MFA

RajeshAlex9 hours ago

Hello Folks,

We are on Apex 24.2.0. We are migrating from Oracle Forms to Apex.

We need to use the database authentication for the users and once authenticated , the page will send a code(MFA) to the users email. We have this code in the database. How do we implement this.

I am using the default login page. I changed the authentication scheme to Database authentication.

I changed the login button to Dynamic instead of the Page submit.

What are the next steps.

In my buttons dynamic action , I have below

apex_authentication.login(
p_username => :P9999_USERNAME,
p_password => :P9999_PASSWORD
);

How do I know this gets authenticated ? If yes I need to run the procedure which will send the code(mfa) to the registered email and then there is another field where the user has to enter this code/pin. Once this pin matches what generated by the system, apex will redirect the user to the main page.

Any help appreciated.

Thank you

Alex

Comments
Post Details
Added 9 hours ago
1 comment
23 views