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 35-12 CREATE_USER_GROUP Parameters
Parameter | Description |
---|---|
|
Primary key of group. |
|
Name of group. |
|
Workspace ID. |
|
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;
Parent topic: APEX_UTIL