Oracle9iAS Portal Developer Kit

activate_portal_user procedure

Contained in package wwsec_api.

Call this procedure to activate an existing but inactive Oracle Portal user.

Note: Sets portal_user to 'Y' in the Oracle Portal user record.

procedure activate_portal_user

(

p_user_name in varchar2

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameter:

p_user_name

The user name of an existing user whose account should be activated.

Datatype: in varchar2

Exceptions:

  • If a Portal User Profile entry for a user with username p_user_name does not exist, even though the user may be present in OID, USER_NOT_FOUND_EXCEPTION is raised.

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

Example:

wwsec_api.activate_portal_user

(

p_user_name => 'USER1'

);

Related topics

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