REMOVE_PERSISTENT_AUTH Procedure

7.15 REMOVE_PERSISTENT_AUTH Procedure

This procedure removes all Persistent Authentication entries for a user and ends all related sessions in the current workspace.

Syntax

APEX_AUTHENTICATION.REMOVE_PERSISTENT_AUTH ( 
    p_username      IN VARCHAR2 );

Parameters

Table 7-7 REMOVE_PERSISTENT_AUTH Parameters

Parameter	Description
`p_username`	The user's name. If enabled, this procedure only invalidates persistent authentication cookies of this user. If set to `NULL`, then invalidates all persistent authentication cookies of all users for this workspace.

Example

This example deletes all Persistant Authentication entries for the current user and ends all sessions of this user in the current workspace.

apex_authentication.remove_persistent_auth(
           p_username         => :APP_USER );