This procedure authenticates the user in the current session.
Login processing has the following steps:
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 4-4 APEX_AUTHENTICATION.LOGIN Procedure Parameters
Parameters | Description |
---|---|
|
The user's name. |
|
The user's password. |
|
If |
Example
This example passes user credentials, username and password, to the authentication scheme.
apex_authentication.login('JOE USER', 'mysecret');
Note:
Parent topic: APEX_AUTHENTICATION