43.34 GET_ACCOUNT_LOCKED_STATUS Function
Returns TRUE
if the account is locked and FALSE
if the account is unlocked. Must be run by an authenticated workspace administrator in a page request context.
Syntax
APEX_UTIL.GET_ACCOUNT_LOCKED_STATUS (
p_user_name IN VARCHAR2
) RETURN BOOLEAN;
Parameters
Table 43-32 GET_ACCOUNT_LOCKED_STATUS Parameters
Parameter | Description |
---|---|
|
The user name of the user account. |
Example
The following example shows how to use the GET_ACCOUNT_LOCKED_STATUS
function. Use this function to check if an Application Express user account (workspace administrator, developer, or end user) in the current workspace is locked.
BEGIN
FOR c1 IN (SELECT user_name FROM apex_users) loop
IF APEX_UTIL.GET_ACCOUNT_LOCKED_STATUS(p_user_name => c1.user_name) THEN
HTP.P('User Account:'||c1.user_name||' is locked.');
END IF;
END LOOP;
END;
Parent topic: APEX_UTIL