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;
Parent topic: APEX_INSTANCE_ADMIN