REMOVE_USER Procedure

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

Syntax

APEX_UTIL.REMOVE_USER(
    p_user_id   IN NUMBER,
    p_user_name IN VARCHAR2);

Parameters

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

REMOVE_USER Parameters

Parameter	Description
`p_user_id`	The numeric primary key of the user account record
`p_user_name`	The user name of the user account

Example

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

BEGIN
APEX_UTIL.REMOVE_USER(p_user_name => 'SCOTT');
END;