Oracle9iAS Portal Developer Kit

update_group_owner procedure

Contained in package wwsec_api.

Call this procedure to perform one of two routines, depending on the value of p_is_owner:

  • Make a group (that is a member of p_group_id) an owner of the group and update the member's privileges accordingly.

  • Remove group owner privileges for a member group that is an owner of the specified group.

procedure update_group_owner

(

p_group_id in number,

p_member_group_id in number,

p_is_owner in number

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_group_id

The unique identifier of a group.

Datatype: in number

p_member_group_id

A unique identifier of another group that is (or will be) a member of p_group_id.

Datatype: in number

p_is_owner

Indicates that p_member_group_id owns p_group_id.

Note: Valid values are OWNER (1) and NOT_OWNER (0).

Datatype: in number

Exceptions:

  • If p_group_id does not exist, a GROUP_NOT_FOUND_EXCEPTION is raised.

  • If the user who initiates the calling routine has insufficient authority to execute the routine, an ACCESS_DENIED_EXCEPTION is raised.

Example:

wwsec_api.update_group_owner

(

p_group_id => 243,

p_member_group_id => 32,

p_is_owner => wwsec_api.NOT_OWNER

);

Related topics

The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio