32.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 account with a random password (not used when the builder authentication is Database Accounts).

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

Syntax

APEX_INSTANCE_ADMIN.CREATE_OR_UPDATE_ADMIN_USER (
    p_username  IN  VARCHAR2 )

Parameters

Parameter	Description
p_username	The username.

Example

The following example creates or updates the user ADMIN.

BEGIN
    apex_instance_admin.create_or_update_admin_user (
        p_username => 'ADMIN',
    COMMIT;
END;