3.7 LOGIN Procedure

This procedure authenticates the user in the current session.

Run authentication scheme's pre-authentication procedure.
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.
Log authentication result.
Redirect.

Syntax

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

Parameters

Table 3-4 APEX_AUTHENTICATION.LOGIN Procedure Parameters

Parameters	Description
`p_username`	The user's name.
`p_password`	The user's password.
`p_uppercase_username`	If `TRUE` then `p_username` is converted to uppercase.

Example

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

apex_authentication.login('JOE USER', 'mysecret');

Note: