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

Syntax

APEX_UTIL.REMOVE_USER (
    p_user_name IN VARCHAR2 );

Parameters

Example

The following examples show how to use the REMOVE_USER procedure to remove a user account by user name using the p_user_name parameter.

BEGIN
   FOR i in 1..10 LOOP
      APEX_UTIL.REMOVE_USER(
         p_user_name => 'USER_'||i);
   END LOOP;
   COMMIT;
END;