6.9 LOGIN Procedure
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 6-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