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 28-83 REMOVE_USER Parameters
Parameter | Description |
---|---|
|
The numeric primary key of the user account record. |
|
The user name of the user account. |
Example
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 p_user_name
parameter).
BEGIN APEX_UTIL.REMOVE_USER(p_user_id=> 99997); END; BEGIN APEX_UTIL.REMOVE_USER(p_user_name => 'FRANK'); END;