EDIT_USER Procedure

This procedure enables a user account record to be altered. To execute this procedure, the current user must have administrative privileges in the workspace.

Syntax

EDIT_USER (
    p_user_id                      NUMBER                  IN,
    p_user_name                    VARCHAR2                IN,
    p_first_name                   VARCHAR2                IN     DEFAULT NULL,
    p_last_name                    VARCHAR2                IN     DEFAULT NULL,
    p_web_password                 VARCHAR2                IN     DEFAULT NULL,
    p_new_password                 VARCHAR2                IN     DEFAULT NULL,
    p_email_address                VARCHAR2                IN     DEFAULT NULL,
    p_start_date                   VARCHAR2                IN     DEFAULT NULL,
    p_end_date                     VARCHAR2                IN     DEFAULT NULL,
    p_employee_id                  VARCHAR2                IN     DEFAULT NULL,
    p_allow_access_to_schemas      VARCHAR2                IN     DEFAULT NULL,
    p_person_type                  VARCHAR2                IN     DEFAULT NULL,
    p_default_schema               VARCHAR2                IN     DEFAULT NULL,
    p_group_idS                    VARCHAR2                IN     DEFAULT NULL,
    p_developer_roles              VARCHAR2                IN     DEFAULT NULL,
    p_description                  VARCHAR2                IN     DEFAULT NULL,
    p_account_expiry               DATE                    IN     DEFAULT NULL,
    p_account_locked               VARCHAR2                IN     DEFAULT 'N',
    p_failed_access_attempts       NUMBER                  IN     DEFAULT 0,
    p_change_password_on_first_use VARCHAR2                IN     DEFAULT 'Y',
    p_first_password_use_occurred  VARCHAR2                IN     DEFAULT 'N');

Parameters

Table: EDIT_USER Parameters describes the parameters available in the EDIT_USER procedure.

EDIT_USER Parameters

Parameter	Description
`p_user_id`	Numeric primary key of the user account
`p_user_name`	Alphanumeric name used for login
`p_first_name`	Informational
`p_last_name`	Informational
`p_web_password`	Clear text password
`p_start_date`	Unused
`p_end_date`	Unused
`p_employee_id`	Unused
`p_allow_access_to_schemas`	A list of schemas assigned to the user's workspace to which the user is restricted
`p_person_type`	Unused
`p_default_schema`	A database schema assigned to the user's workspace, used by default for browsing
`p_group_ids`	Colon-separated list of numeric group IDs
`p_developer_privs`	Colon-separated list of developer privileges (only ADMIN: has meaning to Oracle Application Express)
`p_description`	Informational
`p_account_expiry`	Date password was last updated.
`p_account_locked`	'Y' or 'N' indicating if account is locked or unlocked.
`p_failed_access_attempts`	Number of consecutive login failures that have occurred.
`p_change_password_on_first_use`	'Y' or 'N' to indicate whether password must be changed on first use.
`p_first_password_use_occurred`	'Y' or 'N' to indicate whether login has occurred since password change