CREATE_USER_GROUP Procedure

Assuming you are using Application Express authentication, this procedure creates a user group. To execute this procedure within the context of an Application Express application, the current user must be Application Express workspace administrator and the application must permit modification of the workspace repository.

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 44-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;