fuzziebrain / orclapex-tfa-demo

Demo application to demonstrate use of Two-Factor Authentication to secure Oracle Application Express Applications

Two-Factor Authentication Demo Application

Demo application to demonstrate use of Two-Factor Authentication to secure Oracle Application Express Applications. Click here to see the app in action.

Dependencies

The application demonstrates how Time-based One-time Password (TOTP) was available in OraOpenSource oos-utils since version 1.0.0.

Installation

The repository is structured as follows:

(Project Root)
├───apex
├───packages
└───schema
    └───1.0.0

1. Execute the DDL scripts in schema/1.0.0.
2. Compile the package specification and body for pkg_tfa_apex.
3. Import the APEX application export in apex.

Acknowledgements

• Google Authenticator (TOTP) post by Rabbit.
• QR Code Generator by Kazuhiko Arase.

orclapex-tfa-demo's Issues

Error Compelling the package body for pkg_tfa_apex

Error at line 24: PLS-00201: identifier 'OOS_UTIL_CRYPTO.HASH_STR' must be declared
Error at line 23: PL/SQL: Statement ignored
Error at line 222: PL/SQL: Statement ignored
Error at line 70: PL/SQL: Statement ignored
Error at line 223: PLS-00201: identifier 'OOS_UTIL_TOTP.VALIDATE_OTP' must be declared
Error at line 70: PLS-00201: identifier 'OOS_UTIL_TOTP.GENERATE_SECRET' must be declared

1. create or replace package body pkg_tfa_apex
2. as
3. /**
4. • TODO_Comments