28.14 CREATE_USER_GROUP Procedure

Assuming you are using Application Express authentication, this procedure creates a user group. To execute this procedure, the current user must have administrative privileges in the workspace.

Syntax

APEX_UTIL.CREATE_USER_GROUP(
    p_id                      IN NUMBER default null,
    p_group_name              IN ARCHAR2,
    p_security_group_id       IN NUMBER default null,
    p_group_desc              IN VARCHAR2 default null,);

Parameter

Table 28-12 CREATE_USER_GROUP Parameters

Parameter	Description
`p_id`	Primary key of group.
`p_group_name`	Name of group.
`p_security_group_id`	Workspace ID.
`p_group_desc`	Descriptive text.

Example

The following example demonstrates how to use the CREATE_USER_GROUP procedure to create a new group called 'Managers' with a description of 'text'. Pass null for the p_id parameter to allow the database trigger to assign the new primary key value. Pass null for the p_security_group_id parameter to default to the current workspace ID.

BEGIN
    APEX_UTIL.CREATE_USER_GROUP (
        p_id                => null,         -- trigger assigns PK
        p_group_name        => 'Managers',
        p_security_group_id => null,         -- defaults to current workspace ID
        p_group_desc        => 'text');
END;