2.10 REMOVE_ALL_USER_ROLES Procedure

This procedure removes all assigned roles from a user.

Syntax

APEX_ACL.REMOVE_ALL_USER_ROLES (
    p_application_id IN NUMBER   DEFAULT apex_application.g_flow_id,
    p_user_name      IN VARCHAR2 );

Parameters

Parameter	Description
p_application_id	The application ID for which you want to remove all assigned roles from a user. Defaults to the current application.
p_user_name	The case-insensitive name of the application user to remove all assigned roles from.

Example

The following example uses the REMOVE_ALL_USER_ROLES procedure to remove all assigned roles from the user name 'SCOTT' in application 255.

BEGIN
    APEX_ACL.REMOVE_ALL_USER_ROLES (
        p_application_id  => 255,
        p_user_name       => 'SCOTT' );
END;