Oracle9iAS Portal Developer Kit

deactivate_portal_user procedure

Contained in package wwsec_api.

Call this procedure to deactivate an active Oracle Portal user, preventing the person from logging on to Oracle Portal.

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

procedure deactivate_portal_user

(

p_user_name in varchar2

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_user_name

The user name of the Oracle Portal user whose account is to be deactivated.

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.deactivate_portal_user

(

p_user_name => 'USER1'

);

Related topics

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