CREATE_USER Procedure

This procedure creates a new account record in the Application Express user account table. To execute this procedure, the current user must have administrative privileges.

Syntax

APEX_UTIL.CREATE_USER(
    p_user_id                      NUMBER                  IN     DEFAULT NULL,
    p_user_name                    VARCHAR2                IN,
    p_first_name                   VARCHAR2                IN     DEFAULT NULL,
    p_last_name                    VARCHAR2                IN     DEFAULT NULL,
    p_description                  VARCHAR2                IN     DEFAULT NULL,
    p_email_address                VARCHAR2                IN     DEFAULT NULL,
    p_web_password                 VARCHAR2                IN,
    p_web_password_format          VARCHAR2                IN     DEFAULT NULL,
    p_group_ids                    VARCHAR2                IN     DEFAULT NULL,
    p_attribute_01                 VARCHAR2                IN     DEFAULT NULL,
    p_attribute_02                 VARCHAR2                IN     DEFAULT NULL,
    p_attribute_03                 VARCHAR2                IN     DEFAULT NULL,
    p_attribute_04                 VARCHAR2                IN     DEFAULT NULL,
    p_attribute_05                 VARCHAR2                IN     DEFAULT NULL,
    p_attribute_06                 VARCHAR2                IN     DEFAULT NULL,
    p_attribute_07                 VARCHAR2                IN     DEFAULT NULL,
    p_attribute_08                 VARCHAR2                IN     DEFAULT NULL,
    p_attribute_09                 VARCHAR2                IN     DEFAULT NULL,
    p_attribute_10                 VARCHAR2                IN     DEFAULT NULL);

Parameters

Table: CREATE_USER Procedure Parameters describes the parameters available in the CREATE_USER procedure.

CREATE_USER Procedure Parameters

Parameter	Description
`p_user_id`	Numeric primary key of user account
`p_user_name`	Alphanumeric name used for login
`p_first_name`	Informational
`p_last_name`	Informational
`p_description`	Informational
`p_email_address`	Email address
`p_web_address`	Clear text password
`p_group_ID`	Colon separated list of numeric group IDs
`p_attribute_01` `...` `p_attribute_10`	Arbitrary text accessible with an API

Example

BEGIN
APEX_UTIL.CREATE_USER( 
    P_USER_NAME    => 'NEWUSER1',
    P_WEB_PASSWORD => 'secret99'); 
END;