32.36 UNLOCK_USER Procedure
This procedure unlocks an Oracle APEX workspace user account and optionally also changes the user's password.
Syntax
APEX_INSTANCE_ADMIN.UNLOCK_USER (
p_workspace IN VARCHAR2,
p_username IN VARCHAR2,
p_password IN VARCHAR2 DEFAULT NULL );
Parameters
Parameter | Description |
---|---|
p_workspace |
Workspace of the user. |
p_username |
Name of the user. |
p_password |
New password. If not set, only unlocks the account. |
Example 1
The following example unlocks the user ADMIN
in the instance administration workspace and changes the password.
BEGIN
apex_instance_admin.unlock_user (
p_workspace => 'INTERNAL',
p_username => 'ADMIN',
p_password => 'example password' );
COMMIT;
END;
Example 2
The following example unlocks the user EXAMPLE_USER
in SOME_WORKSPACE
without updating the password.
BEGIN
apex_instance_admin.unlock_user (
p_workspace => 'SOME_WORKSPACE',
p_username => 'EXAMPLE_USER' );
COMMIT;
END;
Parent topic: APEX_INSTANCE_ADMIN