36.116 SET_GROUP_GROUP_GRANTS Procedure
This procedure modifies the group grants for a given group.
Syntax
APEX_UTIL.SET_GROUP_GROUP_GRANTS (
p_group_name IN VARCHAR2,
p_granted_group_names IN apex_t_varchar2 );
Parameters
Table 36-100 SET_GROUP_GROUP_GRANTS Procedure Parameters
Parameter | Description |
---|---|
|
The target group name. |
|
The names of groups to grant to |
Example
This example creates three groups (ACCTS_PAY
, ACCTS_REC
, MANAGER
) and then grants ACCTS_PAY
and ACCTS_REC
to MANAGER
.
apex_util.create_user_group (
p_group_name => 'ACCTS_PAY' );
apex_util.create_user_group (
p_group_name => 'ACCTS_REC' );
apex_util.create_user_group (
p_group_name => 'MANAGER' );
apex_util.set_group_group_grants (
p_group_name => 'MANAGER',
p_granted_group_names => apex_t_varchar2('ACCTS_PAY', 'ACCTS_REC') );
Parent topic: APEX_UTIL