62.107 REMOVE_USER Procedure Signature 1

This procedure removes the user account identified by the primary key. To execute this procedure, the current user must have administrative privilege in the workspace.

Note:

This procedure operates on the native APEX user accounts repository, and is only applicable to applications configured with Oracle APEX Accounts authentication.

Syntax

APEX_UTIL.REMOVE_USER (
    p_user_id   IN NUMBER );

Parameters

Parameter Description
p_user_id The numeric primary key of the user account record.

Example

The following examples show how to use the REMOVE_USER procedure to remove a user account by the primary key using the p_user_id parameter.

BEGIN
    APEX_UTIL.REMOVE_USER(p_user_id=> 99997);
END;