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                       NUMBER                  IN,
    p_group_name               VARCHAR2                IN,
    p_security_group_id        NUMBER                  IN,
    p_group_desc               VARCHAR2                IN);

Parameter

Table: CREATE_USER_GROUP Parameters describes the parameters available in the CREATE_USER_GROUP procedure.

CREATE_USER_GROUP Parameters

Parameter	Description
`p_id`	Primary key of group
`p_group_name`	Arbitrary name
`p_security_group_id`	Workspace ID
`p_group_desc`	Descriptive text

Example

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