44.14 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 |
---|---|
|
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