This procedure sets the APEX_APPLICATION
.G_USER
global variable. SET_USER
requires the parameter P_USER
(VARCHAR2
) which defines a user ID.
Syntax
APEX_CUSTOM_AUTH.SET_USER( p_user IN VARCHAR2);
Parameters
Table 6-9 describes the parameters available in the SET_USER
procedure.
Example
In the following example, if the current application user is NOBODY, then JOHN.DOE is registered as the application user.
IF V('APP_USER') = 'NOBODY' THEN APEX_CUSTOM_AUTH.SET_USER('JOHN.DOE'); END IF;