28.7 CREATE_OR_UPDATE_ADMIN_USER Procedure

This procedure creates an instance administration user account (that is, a user in the INTERNAL workspace). If the account already exists, this procedure also unlocks it and updates the email and password.

This is the procedural equivalent of calling the apxchpwd.sql script.

Syntax

APEX_INSTANCE_ADMIN.CREATE_OR_UPDATE_ADMIN_USER (
    p_username  IN  VARCHAR2,
    p_email     IN  VARCHAR2,
    p_password  IN  VARCHAR2 );

Parameters

Parameter	Description
p_username	The username.
p_email	The user's email address.
p_password	The user's new password.

Example

The following example creates or updates the user ADMIN.

BEGIN
    apex_instance_admin.create_or_update_admin_user (
        p_username => 'ADMIN',
        p_email    => '[e-mail]',
        p_password => 'example password' );
    COMMIT;
END;