58.122 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

Parameter	Description
p_group_name	The target group name.
p_granted_group_names	The names of groups to grant to p_group_name.

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') );