This procedure authenticates the user in the current session.

Login processing has the following steps:

1. Run authentication scheme's pre-authentication procedure.
2. Run authentication scheme's authentication function to check the user credentials (p_username, p_password), returning TRUE on success.
   • If result=true: run post-authentication procedure.
   • If result=true: save username in session table.
   • If result=true: set redirect URL to deep link.
   • If result=false: set redirect URL to current page, with an error message in the notification_msg parameter.
3. Log authentication result.
4. Redirect.

Syntax

APEX_AUTHENTICATION.LOGIN ( 
    p_username              IN VARCHAR2, 
    p_password              IN VARCHAR2, 
    p_uppercase_username    IN BOOLEAN  DEFAULT TRUE
    p_set_persistent_auth   IN BOOLEAN  DEFAULT FALSE ); 

Parameters

Example

This example passes user credentials, username and password, to the authentication scheme.

BEGIN
    apex_authentication.login (
        p_username => 'JOE USER',
        p_password => 'mysecret' );
END;