update_user_owner procedure

Related topics

Contained in package wwsec_api.

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

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

Remove group owner privileges for a user who is currently an owner of the p_group_id.

procedure update_user_owner

(

p_group_id in number,

p_member_person_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 the owned group.

Datatype: in number

p_member_person_id

The unique identifier of a user that is (or will be) a group member.

Datatype: in number

p_is_owner

Indicates if p_member_person_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 p_member_person_id does not exist, an INVALID_PERSON_ID_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_user_owner

(

p_group_id => 243,

p_member_person_id => 32,

p_is_owner => wwsec_api.NOT_OWNER

);

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_group_id	The unique identifier of the owned group. Datatype: in number
p_member_person_id	The unique identifier of a user that is (or will be) a group member. Datatype: in number
p_is_owner	Indicates if p_member_person_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 p_member_person_id does not exist, an INVALID_PERSON_ID_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_user_owner ( p_group_id => 243, p_member_person_id => 32, p_is_owner => wwsec_api.NOT_OWNER );

Related topics
Security API packages	PDK PL/SQL API Reference - Home