43.17 DELETE_USER_GROUP Procedure Signature 1
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.
Syntax
APEX_UTIL.DELETE_USER_GROUP(
p_group_id IN NUMBER);
Parameter
Table 43-15 DELETE_USER_GROUP Procedure Signature 1 Parameters
Parameter | Description |
---|---|
|
Primary key of group. |
Example
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;
Parent topic: APEX_UTIL