Oracle9iAS Portal Developer Kit

add_user_to_list procedure

Contained in package wwsec_api.

Call this procedure to add a user to a group and to allow the user to be set as an owner of the group.

Notes:

  • Owners are users that have been granted administrative privileges over a group.

  • A group can have multiple owners.

procedure add_user_to_list

(

p_person_id in number,

p_to_group_id in number,

p_is_owner in number

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_person_id

The unique ID of a user.

Datatype: in number

p_to_group_id

A unique identifier of the group to be changed.

Datatype: in number:

p_is_owner

Indicates if the person is the owner of the group.

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

Datatype: in number

Exceptions:

  • If p_person_id does not exist, an INVALID_PERSON_ID_EXCEPTION is raised.

  • If p_to_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.

  • If a problem occurs for which an exception has not been defined, an UNEXPECTED_EXCEPTION is raised.

Example:

wwsec_api.add_user_to_list

(

p_person_id => 22,

p_to_group_id => 132,

p_is_owner => wwsec_api.OWNER

);

Related topics

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