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.
APEX_UTIL.REMOVE_USER( p_user_id IN NUMBER, p_user_name IN VARCHAR2);
Table 35-83 REMOVE_USER Parameters
The numeric primary key of the user account record.
The user name of the user account.
The following examples show how to use the
REMOVE_USER procedure to remove a user account. Firstly, by the primary key (using the
p_user_id parameter) and secondly by user name (using the
BEGIN APEX_UTIL.REMOVE_USER(p_user_id=> 99997); END; BEGIN APEX_UTIL.REMOVE_USER(p_user_name => 'FRANK'); END;