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;