Oracle9iAS Portal Developer Kit

user_in_groups function

Contained in package wwsec_api.

Call this function to return a list of the groups to which a specified user belongs.

function user_in_groups

(

p_user_name in varchar2

)

return idarray;

Version: Oracle Portal 3.0.6.6.5 or later

Parameter:

p_user_name

The name of the user whose group membership is being checked.

Datatype: in varchar2

Returns:

This function returns an array filled with the IDs of the groups to which the specified user belongs.

Exceptions:

  • If p_user_name does not exist, a USER_NOT_FOUND_EXCEPTION is raised.

Example:

l_groupid_array wwsec_api.idarray;

l_groupid_array := wwsec_api.user_in_groups

(

p_user_name => 'USER1'

);

Related topics

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