Assuming you are using Application Express authentication, this procedure deletes a user group by providing the primary key of the group. To execute this procedure, the current user must have administrative privileges in the workspace.
APEX_UTIL.DELETE_USER_GROUP( p_group_id IN NUMBER);
Table 28-15 DELETE_USER_GROUP Procedure Signature 1 Parameters
Primary key of group.
The following example demonstrates how to use the
DELETE_USER_GROUP procedure signature 1 to remove the user group called 'Managers', by providing the user group's primary key.
DECLARE VAL NUMBER; BEGIN VAL := APEX_UTIL.GET_GROUP_ID ( p_group_name => 'Managers'); APEX_UTIL.DELETE_USER_GROUP ( p_group_id => VAL); END;